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
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).
Code needs to be done in roughly 3-4 hours!
i will do write these SQL statements. we can finalize the deal in chat. we can discuss details in chat. waiting for your response. cheers!
Bu iş için 19 freelancer ortalamada $122 teklif veriyor
1. CreateaviewcalledProductPriceView,whichcontainsthefollowingthree columns of the Product table: ProductName, ProductID, ProductPrice 2. Retrievethecountofproductswhosepriceisabovetheaverageproductprice 3. List Daha Fazla
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 hav Daha Fazla
Most of my projects are in Sql. My rating speaks for my work
Hi, sir! I've read your description and I am very interested in your project. I am a full-stack web developer and I have deep knowledge on database programming including MySQL, MSSQL, SQLite, MongoDB, etc. Thanks.
Dear,Client. I have read your requirement fully and carefully. Also I looked at your sql file. I know what you really want. As you can see, I am a senior developer. Especially SQL is my major skill. I can satisfy Daha Fazla
We use SQL Server and other RDBMS to power our multi dimensionalfinancial software, these queries are well within our capabilities.
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 ch Daha Fazla
Dear Client For me, Credit is my motto. I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations. I read through the job details extremely carefully and I am Daha Fazla
Hi, I can do that, it is very easy, and I am good at sql, I know how to create views and how to manipulate them, actually I am workin on it right now
Hi I have experience in SQL. Where the database should be created? Because the create query is good. Best Regards Ivan
I have good scripting experience in SQL and Oracle database . If I get a chance I will deliver this in a day . Thanks
Just utilizing sql query statement or stored procedures depending on the complexity and requirements.
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 interested in your project and I would like to know more details. Kindly drop a message so we can discuss.
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 Daha Fazla
Hi I am Expert in the SQL Script Writing and i can provide you the best solution.I am working as a SQL DBA from last 4 Years.