SQL Query PracticeEach slide shows five questions. Students will be required to independentlywrite SQL queries to work out these questions in 25mins. Then, tutors willexplain the questions and the solutions in 10 mins.Jianxin Li (UWA)Lab 22 / 5
Practice SQL Queries - Part 1Q1: How many rows are in the City table?Q2: How many attributes does a City have?Q3: How many tables are in the world database?Q4: How many cities have a population between 500000 and 1000000(inclusive)?Q5: What is the name of the most populous city in the table? (Hint: ORDERBY)Jianxin Li (UWA)Lab 23 / 5
Practice SQL Queries - Part 2Q6: How many different country codes are used in the table? (Hint SELECTDISTINCT)Q7: What is the country code that is earliest in the alphabet? (Hint: ORDER
End of preview. Want to read all 5 pages?
Upload your study docs or become a
Course Hero member to access this document
World population, Jianxin Li, Practice SQL Queries