Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SQL - Structured Query Language Using the Programming database, create the SOL commands that will produce the required results. 1. List the last name, first

image text in transcribed
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

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

Step: 3

blur-text-image

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

Database Processing

Authors: David M. Kroenke, David Auer

11th Edition

B003Y7CIBU, 978-0132302678

More Books

Students also viewed these Databases questions

Question

Are the rules readily available?

Answered: 1 week ago

Question

Are these written ground rules?

Answered: 1 week ago