Tamamlanmış

SQL code writing

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).

Code needs to be done in roughly 3-4 hours!

Beceriler: Microsoft SQL Server, MySQL, Oracle, PHP, SQL

Daha fazlasını gör: sql statements list, sql query examples with answers, learn sql, sql queries for dummies, sql commands, sql tutorial, how to write sql scripts, sql statements, student registration system sql code, program source code writing limericks, sql code extract xls file, sql code bid, institute management system vbnet sql code free, spider code writing, sql code display whole number, extract sql code ssis packages, sql table writing, import export sql code vb6, sql code store project, vba update sql code workbook

İşveren Hakkında:
( 5 değerlendirme ) DOHA, Qatar

Proje NO: #18138257

Seçilen:

Alijhang

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!

%selectedBids___i_period_sub_7% gün içinde 200%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(1 Yorum)
2.6

Bu iş için 19 freelancer ortalamada $122 teklif veriyor

sypsoo

1. CreateaviewcalledProductPriceView,whichcontainsthefollowingthree columns of the Product table: ProductName, ProductID, ProductPrice 2. Retrievethecountofproductswhosepriceisabovetheaverageproductprice 3. List Daha Fazla

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(62 Değerlendirme)
6.4
tdven

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

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(8 Değerlendirme)
5.6
twentyten10

Most of my projects are in Sql. My rating speaks for my work

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(21 Değerlendirme)
4.8
C3guru

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.

in %bids___i_period_sub_35% gün içinde222%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(11 Değerlendirme)
4.4
MaZheng225

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

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(9 Değerlendirme)
4.1
jssymm

We use SQL Server and other RDBMS to power our multi dimensionalfinancial software, these queries are well within our capabilities.

in %bids___i_period_sub_35% gün içinde194%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
4.0
sambestsolutions

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

in %bids___i_period_sub_35% gün içinde111%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(7 Değerlendirme)
3.0
yesikov1224

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

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)
3.1
hadjer11

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

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
Justivan53

Hi I have experience in SQL. Where the database should be created? Because the create query is good. Best Regards Ivan

in %bids___i_period_sub_35% gün içinde67%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
0.0
mmrmultimedias

mmrgvjx

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
niteshgen

I have good scripting experience in SQL and Oracle database . If I get a chance I will deliver this in a day . Thanks

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
chntiger

Just utilizing sql query statement or stored procedures depending on the complexity and requirements.

in %bids___i_period_sub_35% gün içinde166%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
wimaxs

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.

in %bids___i_period_sub_35% gün içinde111%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
i4ConsultantDev

Hi, I am interested in your project and I would like to know more details. Kindly drop a message so we can discuss.

in %bids___i_period_sub_35% gün içinde60%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
sdrdh

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
rahulsharma9530

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.

in %bids___i_period_sub_35% gün içinde88%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0