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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!