Back to Categories
Question 1 of 50
Informatics Practices > Database Query using SQL > Querying And Grouping
Progress: 0%
Success Rate: 0%
Question 1
Consider the following table
CLIENTTable: CLIENT
I. Which attribute in the Table can be considered as the Candidate Keys? Provide justification for your answer. II. Write a suitable SQL query to remove those rows of table CLIENT whose city is DELHI. III. Write the output of the following SQL Query:
SELECT CITY, COUNT(*) FROM CLIENT GROUP BY CITY HAVING COUNT(CITY)<>2;0 of 50 answered
Current Session
Questions Answered0
Correct Answers0
Session Success Rate0%
Ready to Start! 🚀
Community Stats
Active Learners31
Questions Attempted625
Community Success Rate69%
Track Your Progress
Sign up to save your practice progress and get personalized insights across all topics.