Page 1 of 1

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
by answerhappygod
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?