Find Jobs
Hire Freelancers

SQL code writing

$30-250 USD

Completed
Posted over 5 years ago

$30-250 USD

Paid on delivery
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).
Project ID: 18138257

About the project

14 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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!
$200 USD in 3 days
5.0 (1 review)
2.6
2.6
14 freelancers are bidding on average $113 USD for this job
User Avatar
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.
$50 USD in 3 days
4.8 (10 reviews)
5.6
5.6
User Avatar
Most of my projects are in Sql. My rating speaks for my work
$30 USD in 3 days
5.0 (30 reviews)
5.0
5.0
User Avatar
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.
$111 USD in 3 days
5.0 (17 reviews)
4.7
4.7
User Avatar
We use SQL Server and other RDBMS to power our multi dimensionalfinancial software, these queries are well within our capabilities.
$194 USD in 2 days
4.6 (1 review)
3.8
3.8
User Avatar
Hi, I am interested in your project and I would like to know more details. Kindly drop a message so we can discuss.
$60 USD in 7 days
5.0 (4 reviews)
2.0
2.0
User Avatar
Hi I have experience in SQL. Where the database should be created? Because the create query is good. Best Regards Ivan
$67 USD in 3 days
5.0 (1 review)
0.9
0.9
User Avatar
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have good scripting experience in SQL and Oracle database . If I get a chance I will deliver this in a day . Thanks
$155 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Just utilizing sql query statement or stored procedures depending on the complexity and requirements.
$166 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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.
$111 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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
$35 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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.
$88 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of QATAR
DOHA, Qatar
3.7
5
Member since Oct 26, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.