Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i cant seem to figure out how to get this to run on SQL. this are the problems i need figured out i keep getting

i cant seem to figure out how to get this to run on SQL.image text in transcribed

this are the problems i need figured out i keep getting errors

11:59 PM Import the MDC database schema in workbench or phpmyadmin. Attached is the sql file that you need to import/execute (execute all of the code by clicking the lightning button , if using workbench). Then, using that MDC database schema, write SQL queries to do the following: 1. List the LastName, FirstName, and Phone for all customers with a FirstName of "Nikki'. 2. List the Dateln, and DateOut of all orders in excess of $100.00 3. List the LastName, FirstName, and Phone of all customers whose first name starts with 'B'. 4. List the LastName, FirstName, and Phone of all customers whose last name includes the characters 'cat'. 5. List the LastName, FirstName, and Phone for all customers whose second and third digits (from the left) of their phone number are 23. For example, any phone number with an area code of "723" would meet the criteria 6. Determine the maximum, minimum, and average of TotalAmount. 7. Count the number of customers. 8. Group customers by LastName and then by FirstName. Count the number of customers having each combination of LastName and FirstName. mdc-ch2_latest.sql mdc.JPG

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

Concepts Of Database Management

Authors: Philip J. Pratt, Joseph J. Adamski

4th Edition

0619064625, 978-0619064624

More Books

Students also viewed these Databases questions