Answered You can buy a ready-made answer or pick a professional tutor to order an original one.
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,
- @
- 165 orders completed
- ANSWER
-
Tutor has posted answer for $15.00. See answer's preview
***** 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 *************************************************************************************