Answered You can buy a ready-made answer or pick a professional tutor to order an original one.

QUESTION

MySQL Learning Team Assignment

Hello,

I am taking an Database (My SQL) class, and I need help with this assignment for week 4. I need this done by Saturday 03/18/2017

I have attached the previous weeks assignments as reference for week 4.

Week 4 Assignment

Complete work on your Learning Team Database.

Execute the following queries in the Diamond Broker database:

  • Create an 1-page inventory list showing all the attributes for each diamond in inventory (both in stock and not in stock)
  • Show the total price and costs for all in stock inventory items
  • Show a 1-page list of all diamonds that are in stock and have a carat weight of over 1.0 carats
  • Show a 1-page list of customer names and order numbers for those customers that have placed an order in the past twelve months
  • Show a 1-page list of all orders with customer name and include all items that are on that order

Thanks,

Show more
  • @
  • 165 orders completed
ANSWER

Tutor has posted answer for $15.00. See answer's preview

$15.00

***** 1  Query ************ ******** ********** *********************************************************** ********************************************************************************************************************************************************************* ***************************************************************************************************************************************** ******************************************************************************************************************************** ****************************** ********************* **************************************************** ******************************************************** into ***** table insertintoOrderTablevalues(3000 **** 1007'09/04/2015')insertintoOrderTablevalues(3001 2000 1006 ******************************************** **** **** ******************************************** **** **** ******************************************** **** 1008 ******************************************** **** 1009 ******************************************** **** 1010 ********************************************** 2012 1007 ******************************************** **** **** ******************************************** 2002 **** ******************************************** 2000 1013 ************************ ************************************ *********** ********************************* ************ ********************************** (2002'Peter ********************************** *********** Benoit')insertintoCustomervalues ********************************************** *********** ********************************* *********** Kenneth')insertintoCustomervalues ************ ********************************* ************** *********************************** ************** Robert ************************** (2011'Michaels ****** ************************** (2012'Michaels ********* insertintoCustomervalues *********** ********************************* (2014'Thomas Robert ************************** ************* ********************** into *************************************** *** ********************************************************* *** ********************************************************* *** 950'VVS1''V-shape' *************************************** *** 1150'VVS2''V-shapE'13'I''Y')insertintoInventoryvalues(1008 239 ***************** *************************************** 240 ******************************************************** *** 650'VS1''V-shape'03'H''Y')insertintoInventoryvalues(1011 *** ********************************************************* *** 850'VVS2''V-shape' *************************************** *** 950'VVS2''V-shape'13'J''N')insertintoInventoryvalues(1014 *** ********************************************************** 230 450'VVS1''V-shape' 43'E''Y')   --QUERIES----------------------------- --Create ** ****** ********* **** showing all *** ********** for each diamond ** ********* ***** ** ***** and not in *************************************** *** ***** ***** *** ***** *** *** ** stock ********* ************************************************************************* * 1-page list of *** ******** **** *** ** ***** and have * ***** weight ** over ** ************************************************************* ************ * ****** **** ** customer names *** ***** numbers *** ***** customers **** **** placed ** ***** ** *** **** ****** months select*fromOrderTablewhereorder_datein(selectorder_datefromOrderTableWHEREorder_date>DATEADD(year-1GETDATE())) --Show * ****** **** ** *** orders with ******** **** *** ******* *** ***** that are ** that *************************************************************************************

Click here to download attached files: QUERY RESULTS doc.zip
or Buy custom answer
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question