SQL1 questions.pdf - Databases - SQL 1 Jianxin Li School of...

• Notes
• 5
• 100% (1) 1 out of 1 people found this document helpful

This preview shows page 1 - 5 out of 5 pages.

Databases - SQL 1Jianxin LiSchool of Computer Science & Software EngineeringUniversity of Western AustraliaJianxin Li (UWA)Lab 21 / 5
We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
Chapter 3 / Exercise 65
Intermediate Algebra
Tussy/Gustafson
Expert Verified
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?

Course Hero member to access this document

Term
One
Professor
N/A
Tags
World population, Jianxin Li, Practice SQL Queries
We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
The document you are viewing contains questions related to this textbook.
Chapter 3 / Exercise 65
Intermediate Algebra
Tussy/Gustafson
Expert Verified