Assignment -Sorting and Grouping -Part 1 Select the sampdb database and use the tickets table for the following queries.
Posted: Fri May 20, 2022 6:33 pm
Assignment -Sorting and Grouping -Part 1
Select the sampdb database and use the tickets table for the
following queries.
Write queries that answer each question below.
Submit BOTH your SQL statements AND a screen shot of the
results. Please make sure that your SQL statements are very clearly
legible and screen shots are not too small.
Question#1
What are the 10 tickets with the highest point values?
Question#2
How many tickets are there?
Question#3
What is the total point value for all tickets
combined?
Question#4
What is the lowest ticket point value?
Question#5
What is the average ticket point value?
Select the sampdb database and use the tickets table for the
following queries.
Write queries that answer each question below.
Submit BOTH your SQL statements AND a screen shot of the
results. Please make sure that your SQL statements are very clearly
legible and screen shots are not too small.
Question#1
What are the 10 tickets with the highest point values?
Question#2
How many tickets are there?
Question#3
What is the total point value for all tickets
combined?
Question#4
What is the lowest ticket point value?
Question#5
What is the average ticket point value?