I need a SQL code to be written,
Create the database using the attached SQL script ([login to view URL]) Then, write SQL statements for following:
1. CreateaviewcalledProductPriceView,whichcontainsthefollowingthree columns of the Product table: ProductName, ProductID, ProductPrice
2. Retrievethecountofproductswhosepriceisabovetheaverageproductprice
3. List the customer ids and customer names of all customers who purchased the product ‘Zzz Bag’
4. CreateaviewcalledSalesTransactionShort,whichshowsforeachsales transaction the transactionid (TID) and the name of the customer for that transaction
5. [login to view URL] should have two columns: ProductID and NumOfCustomers.
6. Display the TID, CustomerName, and TDate for sales transactions involving a customer buying a product whose ProductName is Dura Boot.
7. [login to view URL] have three columns: customerID, customerName, NumofSalesTransactions.
8. Foreachproductcategory,displaytheCategoryIDandthetotalnumberof items purchased in the category.
9. DisplaytheProductID,ProductName,ProductPrice,VendorName,and CategoryName for all products. Sort the results by ProductID in descending order.
[login to view URL] each product that was sold in a salestransaction list the salestransactionid, the productID, the productname, the quantity, and the total price (i.e., product price * quantity).
Hi.
I am interested in your project. I can program in several languages / frameworks like PHP, ruby (and ruby on rails), NodeJs, AngularJs, SQL and GoLang among others.
Let me know more about your project. I have the availability to start as soon as possible.
Thank you.
Hi
I am an devops engineer experienced in mysql fro more than 5 years. I can store db with given sql file and create given queries and output for you. Please message to discuss further on this.
Thanks
Note-please check my profile for past projects and reviews.
I have gone through all points that you require. I have found this interesting job and also completed most of the points mentioned. I would be more happy to get this project as it is relevant for me.
Hi,
I am Siddardh and the have been working on SQL systems for quite awhile. This project is straight forward and I will be able to complete this in around 1 day.
Looking forward to working on this project.
Regards,
Siddardh