This Problem was previously asked on the site, But the
solution contained some errors, Please do not use the existing
solution and solve it in another correct way, Thank
you!
This Problem Was Previously Asked On The Site But The Solution Contained Some Errors Please Do Not Use The Existing So 1 (223.84 KiB) Viewed 22 times
This Problem Was Previously Asked On The Site But The Solution Contained Some Errors Please Do Not Use The Existing So 2 (351.44 KiB) Viewed 22 times
Given the ORDER, ORDER_DETAIL, CUSTOMER, and PRODUCT tables. CUSTOMER CUSTOMER_ID CUSTOMER_NAME 1565 Emre 1789 Akif 1265 Eyup 4537 Fatih 6542 Murat CITY CITY_ID CITY_NAME 1 Gaziantep 2 Balıkesir 3 Edirne 4 Van 5 Rize 6 Kayseri ORDER ORDER_ID ORDER DATE 1 05.08.2012 2 11.04.2015 3 12.06.2013 4 02.05.2015 5 02.09.2014 ADDRESS CITY_ID CITY_NAME Gatem 2 Rasaf yolu 1 Damlacık 6 köyü Seyrantepe 1 Sarıgüllük PRODUCT PRODUCT_ID PRODUCT_NAME PRICE (TL) 1 Bilgisayar 3250 2 Telefon 1800 3 Monitör 650 4 Klavye 45 5 1200 Televizyon Masa 6 60 CUSTOMER_ID 1565 1265 4537 6542 1565 ORDER_DETAIL ORDER_ID PRODUCT_ID 1 1 1 3 1 4 2 4 3 4 3 5 4 1 4 3 4 5 4 6 5 1 5 3
1. Delete the customer(s) who not ordering. 2. Update CITY_NAME of CUSTOMER table for all customers. Take CITY_NAME from CITY table according to CITY_ID of CUSTOMER table. 3. Display the ORDER_ID and how many product(s) ordered for per order 4. Display the ORDER_ID and PRODUCT_NAME from ORDER_DETAIL table where ordered product count>1. 5. Display the details of order as "ORDER_ID, ORDER_DATE, CUSTOMER_NAME, CITY_NAME" of all orders. Combine three tables using without JOIN method.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!