Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i meed question 4 5 and 6 SQL - Structured Query Language Using the Programming database, create the SQL commands that will produce the required

i meed question 4 5 and 6 image text in transcribed
SQL - Structured Query Language Using the Programming database, create the SQL 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 StudentCellList. 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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Upgrading Oracle Databases Oracle Database New Features

Authors: Charles Kim, Gary Gordhamer, Sean Scott

1st Edition

B0BL12WFP6, 979-8359657501

More Books

Students also viewed these Databases questions

Question

Explain how a business banker prices a commercial loan?

Answered: 1 week ago

Question

2. What do you believe is at the root of the problem?

Answered: 1 week ago