Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Book I got these out of: MYSQL murach Enter and run your own SELECT statements In these exercises, you ll enter and run your own

Book I got these out of: MYSQL murach
Enter and run your own SELECT statements In these exercises, youll enter and run your own SELECT statements. To do that, you can open the script for an example that is similar to the statement you need to write, copy the statement into a new SQL tab, and modify the statement. That can save you both time and syntax errors.
8. Write a SELECT statement that returns three columns from the Vendors table: vendor_name, vendor_contact_last_name, and vendor_contact_first_name. Then, run this statement to make sure it works correctly. Add an ORDER BY clause to this statement that sorts the result set by last name and then first name, both in ascending sequence. Then, run this statement again to make sure it works correctly. This is a good way to build and test a statement, one clause at a time.
9. Write a SELECT statement that returns one column from the Vendors table named full_name that joins the vendor_contact_last_name and vendor_contact_first_name columns. Format this column with the last name, a comma, a space, and the first name like this:
Doe, John
Sort the result set by last name and then first name in ascending sequence. Return only the contacts whose last name begins with the letter A, B, C, or E. This should retrieve 41 rows.
10. Write a SELECT statement that returns these column names and data from the Invoices table:
Due Date The invoice_due_date
Invoice Total The invoice_total column
10%10% of the value of invoice_total
Plus 10% The value of invoice_total plus 10%
Return only the rows with an invoice total thats greater than or equal to 500 and less than or equal to 1000. This should retrieve 12 rows. Sort the result set in descending sequence by invoice_due_date.
11. Write a SELECT statement that returns these columns from the Invoices table:
invoice_number The invoice_number column
invoice_total The invoice_total column
payment_credit_total Sum of the payment_total and credit_total columns
balance_due The invoice_total column minus the payment_total and credit_total columns
Return only invoices that have a balance due thats greater than $50. Sort the result set by balance due in descending sequence. Use the LIMIT clause so the result set contains only the rows with the 5 largest balances.
I am having trouble with these exercises, I have done the 1-7 though.

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

Data Mining Concepts And Techniques

Authors: Jiawei Han, Micheline Kamber, Jian Pei

3rd Edition

0123814790, 9780123814791

More Books

Students also viewed these Databases questions

Question

- 2 x 3 ( - 3 x 2 - 6 x )

Answered: 1 week ago

Question

What is the best conclusion for Xbar Chart? UCL A X B C B A LCL

Answered: 1 week ago