Question: SQL - Structured Query Language Using the Programming database, create the SOL commands that will produce the required results. 1. List the last name, first
SQL - Structured Query Language Using the Programming database, create the SOL commands that will produce the required results. 1. List the last name, first name, and cell phone numbers for all students. Sort by last name. Name the query StudentCell List. 2. List the last name, first name, and cell phone numbers for all male students. Sort by last name. Name the query MaleStudents. 3. List the contract ID, contract date, session type, cost and a new field that will increase the cost by $10. Name this new field UpdatedCost. Name the query NewCostlist. 4. List the tutor's last name, student ID, contract date, length, and cost for all group sessions. Sort by tutor's last name and then by student ID. Name the query GroupSessions. 5. List the student ID, last name, first name, and contract date for all students from Raleigh who are taking private lessons. Sort by student's last name. Name the query RaleighPrivate. 6. List the student ID, first name, last name, contract date, and cost for all students who are either from Cary or are taking semi-private lessons. Sort in descending order by contract date. Name the query CaryOrSemi. 7. List the lowest, highest, and average cost for all contracts. Name the query CostStatistics. 8. List each city and the lowest, highest, and average cost for all contracts for that city. Name the query CostStatisticsByCity
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
