Computer Science > QUESTIONS & ANSWERS > CS 206 Write a SELECT statement that returns one column from the Customers table named full_name t (All)

CS 206 Write a SELECT statement that returns one column from the Customers table named full_name that joins the last_name and 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 in ascending sequence.

Document Content and Description Below

Instructions for creating the database and more information can be found at the following link: https://drive.google.com/drive/folders/11lV5T0ojoq4wKe44ZQnA3vGOpqZXgG1U?usp=sharing ** 1. Write a S... ELECT statement that returns one column from the Customers table named full_name that joins the last_name and 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 in ascending sequence. 2. Write a SELECT statement that returns these columns from the Products table: product_name The product_name column list_price The list_price column date_added The date_added column Return only the rows with a list price that's greater than 500 and less than 2000. Sort the result set in descending sequence by the date_added column. 3. Write a SELECT statement that returns these column names and data from the Products table: product_name - The product_name column list_price - The list_price column discount_percent - The discount_percent column discount_amount - A column that's calculated from the previous two columns discount_price - A column that's calculated from the previous three columns Round the discount_amount and discount_price columns to 2 decimal places. Sort the result set by discount price in descending sequence. Use the LIMIT clause so the result set contains only the first 5 rows. 4. Write a SELECT statement that returns these column names and data from the Order_Items table: item_id The item_id column item_price The item_price column discount_amount The discount_amount column quantity The quantity column price_total A column that's calculated by multiplying the item price by the quantity discount_total A column that's calculated by multiplying the discount amount by the quantity item_total A column that's calculated by subtracting the discount amount from the item price and then multiplying by the quantity Only return rows where the item_total is greater than 500. Sort the result set by item total in descending sequence. 5. Write a SELECT statement that returns these columns from the Orders table: order_id The order_id column order_date The order_date column ship_date The ship_date column Return only the rows where the ship_date column contains a null value. 6. Write a SELECT statement that joins the Categories table to the Products table and returns these columns: category_name, product_name, list_price. 7. Write a SELECT statement that joins the Customers table to the Addresses table and returns these columns: first_name, last_name, line1, city, state, zip_code. NOTE - The WHERE clause is NOT needed for this one. 8. Write a SELECT statement that joins the Customers, Orders, Order_Items, and Products tables. This statement should return these columns: last_name, first_name, order_date, product_name, item_price, discount_amount, and quantity. Sort the final result set by last_name, order_date, and product_name. 9. Write a SELECT statement that returns these two columns: category_name: The category_name column from the Categories table product_id: The product_id column from the Products table Following each of these, write a SELECT statement that shows the results. Also, please use the MyGuitarShop Database. 10. Write an INSERT statement that adds this row to the Categories table: category_name: Brass Code the INSERT statement so MySQL automatically generates the category_id column. 11. Write an UPDATE statement that modifies the row you just added to the Categories table. This statement should change the category_name column to "Woodwinds", and it should use the category_id column to identify the row. NOTE - Double-check that the correct row is updated. 12. Write a DELETE statement that deletes the row you added to the Categories table in exercise 10. This statement should use the category_id column to identify the row. 13. Write an INSERT statement that adds this row to the Products table: product_id: The next automatically generated ID category_id: 4 product_code: dgx_640 product_name: Yamaha DGX 640 88-Key Digital Piano description: Long description to come. list_price: 799.99 discount_percent: 0 date_added: Today's date/time. Use a column list for this statement. NOTE - You could use the NOW() function for the date_added column. 14. Write an UPDATE statement that modifies the product you added in #13. This statement should change the discount_percent column from 0% to 35%. NOTE - Using the discount_percent condition in the WHERE clause may UPDATE more rows than needed. 15. Write a SELECT statement that returns these columns: The count of the number of orders in the Orders table The sum of the tax_amount columns in the Orders table 16. Write a SELECT statement that returns three columns: email_address, order_id, and the order total for each customer. To do this, you can group the result set by the email_address and order_id columns. In addition, you must calculate the order total from the columns in the Order_Items table. 17. Write a SELECT statement that returns the name and discount percent of each product that has a unique discount percent. In other words, don't include products that have the same discount percent as another product. Sort the results by the product_name column. 18. Write a SELECT statement that returns these columns from the Orders table: The order_id column The order_date column A column named approx_ship_date that's calculated by adding 2 days to the order_date column The ship_date column A column named days_to_ship that shows the number of days between the order date and the ship date When you have this working, add a WHERE clause that retrieves just the orders for May 2015. Computer Science Engineering & Technology MYSQLCS 206 [Show More]

Last updated: 1 year ago

Preview 1 out of 19 pages

Reviews( 0 )

Recommended For You

 English> QUESTIONS & ANSWERS > Imagine you have landed on a strange planet. Write a two- to three-page fictional narrative (All)

preview
Imagine you have landed on a strange planet. Write a two- to three-page fictional narrative

Question Answered step-by-step Fictional narrative attachment1.png Image transcription text Choose a prompt Prompt 1: Imagine you have landed on a strange planet. Write a two- to three-p...

By Cheryshev , Uploaded: Jul 29, 2021

$8

 Computer Science> QUESTIONS & ANSWERS > University of South Africa COS COS 4851 Question 3 [5] Write a tail-recursive procedure countvars (List, N) that counts the number of uninstantiated variables in the list List and returns... (All)

preview
University of South Africa COS COS 4851 Question 3 [5] Write a tail-recursive procedure countvars (List, N) that counts the number of uninstantiated variables in the list List and returns...

Question Answered step-by-step Question 3 [5] show to to do a tail-recursive procedure... q33.PNG Image transcription text Question 3 [5] Write a tail-recursive procedure countvars (List, N) th...

By Cheryshev , Uploaded: Jul 19, 2021

$8

 Information Technology> QUESTIONS & ANSWERS > You are required to write a Bourne Again Shell Script (bash) to manage a menu-driven program. When executed the user should be presented with a menu... Share Question Link copied! (All)

preview
You are required to write a Bourne Again Shell Script (bash) to manage a menu-driven program. When executed the user should be presented with a menu... Share Question Link copied!

Question You are required to write a Bourne Again Shell Script (bash) to manage a menu-driven program. When executed the user should be presented with a menu with four (1) options: Print the...

By d.occ , Uploaded: Jun 16, 2021

$7

 Computer Science> QUESTIONS & ANSWERS > Engineering & Technology Computer Science Write a program that: Inputs a 1x8 vector of single-digit integers Stores them into an 8-entry 32-bit Integer array,'V'. It is not completely trivial... (All)

preview
Engineering & Technology Computer Science Write a program that: Inputs a 1x8 vector of single-digit integers Stores them into an 8-entry 32-bit Integer array,'V'. It is not completely trivial...

Question Write a program that: Inputs a 1x8 vector of single-digit integers Stores them into an 8-entry 32-bit Integer array, "V". It is not completely trivial to do this given the Syscalls ava...

By Muchiri , Uploaded: Apr 22, 2021

$7

 Computer Science> QUESTIONS & ANSWERS > University of Wisconsin COMPUTER S COMPUTER S 245 Your task is to write a MIPS assembly code sequence the calculates the Fibonacci Sequence (see below) and stores the values into an array based on... Share Question (All)

preview
University of Wisconsin COMPUTER S COMPUTER S 245 Your task is to write a MIPS assembly code sequence the calculates the Fibonacci Sequence (see below) and stores the values into an array based on... Share Question

University of Wisconsin COMPUTER S COMPUTER S 245 Your task is to write a MIPS assembly code sequence the calculates the Fibonacci Sequence (see below) and stores the values into an array based...

By Expert Tutor , Uploaded: Apr 05, 2021

$10

 Computer Science> QUESTIONS & ANSWERS > Engineering & Technology Computer Science Your task is to write a MIPS assembly code sequence the calculates the benacci Sequence (see below) and stores the values into an array based on the... Share Question (All)

preview
Engineering & Technology Computer Science Your task is to write a MIPS assembly code sequence the calculates the benacci Sequence (see below) and stores the values into an array based on the... Share Question

Engineering & Technology Computer Science Your task is to write a MIPS assembly code sequence the calculates the benacci Sequence (see below) and stores the values into an array based on the... S...

By Muchiri , Uploaded: Apr 01, 2021

$7

 Computer Science> QUESTIONS & ANSWERS > Engineering & Technology Computer Science Your task is to write a MIPS assembly code sequence the calculates the benacci Sequence (see below) and stores the values into an array based on the... Share Question (All)

preview
Engineering & Technology Computer Science Your task is to write a MIPS assembly code sequence the calculates the benacci Sequence (see below) and stores the values into an array based on the... Share Question

Engineering & Technology Computer Science Your task is to write a MIPS assembly code sequence the calculates the benacci Sequence (see below) and stores the values into an array based on the... S...

By Expert Tutor , Uploaded: Apr 01, 2021

$7

 Computer Science> QUESTIONS & ANSWERS > California State University, Northridge COMP COMP 182 Project 03.pdf X K C O File | / Update E Project 03.pdf 1 / 1 | 110% + (RADIX SORT) Write a program that randomly generates 20 integers (0-10000) and... Share Question (All)

preview
California State University, Northridge COMP COMP 182 Project 03.pdf X K C O File | / Update E Project 03.pdf 1 / 1 | 110% + (RADIX SORT) Write a program that randomly generates 20 integers (0-10000) and... Share Question

Question i have a project due and i am having trouble using radix sort and not sure how to implement within code. Screen Shot 2021-02-25 at 1.36.25 PM.png

By Muchiri , Uploaded: Mar 10, 2021

$7

 Health Care> QUESTIONS & ANSWERS > [Solved] MANAGEMENT BSB51915R2 / LA019818 Assessment 2 BSBWHS501 Ed 2/ a) Write a policy (one page) for this (All)

preview
[Solved] MANAGEMENT BSB51915R2 / LA019818 Assessment 2 BSBWHS501 Ed 2/ a) Write a policy (one page) for this

a) Write a policy (one page) for this organisation, clearly outlining the organisation's commitment to WHS and those responsible for ensuring compliance. BSBWHS501: Assessment 2 What you have to do...

By QUIZBANK , Uploaded: Dec 18, 2020

$12

 Business> QUESTIONS & ANSWERS > [Solved] Write a 4-6 page essay on two of the following questions. Your total assignment should be 4-6 pages (All)

preview
[Solved] Write a 4-6 page essay on two of the following questions. Your total assignment should be 4-6 pages

Write a 4-6 page essay on two of the following questions. Your total assignment should be 4-6 pages long, plus an additional bibliography page. Please be very careful to cite your resources, including...

By QUIZBANK , Uploaded: Dec 16, 2020

$19

$12.00

Add to cart

Instant download

Can't find what you want? Try our AI powered Search

OR

GET ASSIGNMENT HELP
83
0

Document information


Connected school, study & course



About the document


Uploaded On

Mar 15, 2023

Number of pages

19

Written in

Seller


seller-icon
QuizMaster

Member since 4 years

1074 Documents Sold


Additional information

This document has been written for:

Uploaded

Mar 15, 2023

Downloads

 0

Views

 83

Document Keyword Tags

THE BEST STUDY GUIDES

Avoid resits and achieve higher grades with the best study guides, textbook notes, and class notes written by your fellow students

custom preview

Avoid examination resits

Your fellow students know the appropriate material to use to deliver high quality content. With this great service and assistance from fellow students, you can become well prepared and avoid having to resits exams.

custom preview

Get the best grades

Your fellow student knows the best materials to research on and use. This guarantee you the best grades in your examination. Your fellow students use high quality materials, textbooks and notes to ensure high quality

custom preview

Earn from your notes

Get paid by selling your notes and study materials to other students. Earn alot of cash and help other students in study by providing them with appropriate and high quality study materials.


$12.00

WHAT STUDENTS SAY ABOUT US


What is Browsegrades

In Browsegrades, a student can earn by offering help to other student. Students can help other students with materials by upploading their notes and earn money.

We are here to help

We're available through e-mail, Twitter, Facebook, and live chat.
 FAQ
 Questions? Leave a message!

Follow us on
 Twitter

Copyright © Browsegrades · High quality services·