Select the sampdb database and use the tickets table for the following queries. Write queries that answer each question
Posted: Fri May 20, 2022 6:56 pm
Select the sampdb database and use the tickets table for the
following queries.
Write queries that answer each question below.
Submit your SQL statements AND a screen shot of the results.
Please make sure that
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?
following queries.
Write queries that answer each question below.
Submit your SQL statements AND a screen shot of the results.
Please make sure that
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?