TOTAL: 15 points Part-A) 8 points 1) Write the join query to produce following table from bike database (2 point) (note

Post by **answerhappygod** » Wed Mar 30, 2022 9:25 am

: Total 15 Points Part A 8 Points 1 Write The Join Query To Produce Following Table From Bike Database 2 Point Note 1 (124.51 KiB) Viewed 41 times

TOTAL: 15 points Part-A) 8 points 1) Write the join query to produce following table from bike database (2 point) (note here: first_name and last_names of customers) FIRST_NAME LAST_NAME 1 Sharie Alvarez 2 Bettie Glover 3 Marilyn Frank 4 Sheba Knapp 5 Aleta Mack 6 Reena Higgins 7 Ami Mcmahon CUSTOMER_ID SHIPPED_DATE 327 16-03-17 328 17-06-27 329 17-04-19 330 18-03-20 331 16-08-22 332 16-04-01 333 17-11-13 Assignment #3 2) Write the join query to produce following table from bike database (2 point) (note here: first_name and last_nanes of staff)
FIRST_NAME LAST_NAME 1 Fabiola Jackson 2 Mireya Copeland 3 Mireya Copeland 4 Mireya Copeland 5 Mireya Copeland 6 Mireya Copeland 7 Mireya Copeland 8 Mireya Copeland 9 Mireya Copeland 10 Mireya Copeland 11 Mireya Copeland 12 Mireya Copeland 13 Mireya Copeland 14 Mireya Copeland 15 Mireya Copeland CUSTOMER_ID SHIPPED_DATE (null) (null) 1214 18-01-17 253 18-01-24 1186 18-02-03 983 18-02-04 1254 18-02-11 109 18-03-02 300 18-03-07 1231 18-03-07 1445 18-03-10 518 18-03-16 3 18-03-29 302 18-04-02 31 (null) 81 (null) 3) Write the join query to produce following table from bike database (2 point) (note here : first_name and last_nanes of staff) FIRST_NAME LAST_NAME CUSTOMER_ID SHIPPED_DATE 1 Mireya Copeland 532 17-01-05 2 Marcelene Boyer 512 17-01-05 3 Venita Daniel 1302 17-01-06 4 Marcelene Boyer 550 17-01-07 5 Marcelene Boyer 1093 17-01-07 6 Genna Serrano 673 17-01-08 7 Venita Daniel 847 17-01-10 8 Genna Serrano 901 17-01-11 9 Marcelene Boyer 439 17-01-10 10 Marcelene Boyer 1199 17-01-10 11 Mireya Copeland 975 17-01-11 12 Venita Daniel 283 17-01-11 13 Marcelene Boyer 684 17-01-11 14 Genna Serrano 1153 17-01-13 15 Mireya Copeland 729 17-01-12 16 Venita Daniel 190 17-01-13 17 Layla Terrell 985 17-01-13
Assignment #3 4) Write the join query to produce following table from bike database (2 points) (note here : THREE TABBLE JOIN ) Customer_Name ORDER_ID CUSTOMER_ID ORDER_DATE | STAFF_NAME 1 BrigidSharp 1348 1214 18-01-15 MireyaCopeland 2 MauriceNorton 1358 253 18-01-21 MireyaCopeland 3 KieshaBond 1376 1186 18-02-01 MireyaCopeland 4 MargueriteBerger 1378 983 18-02-02 MireyaCopeland 5 DungReid 1386 1254 18-02-09 MireyaCopeland 6 MonicaSears 1411 109 18-03-01 MireyaCopeland 7 RayfordSimon 1417 300 18-03-04 MireyaCopeland 8 SeleneVega 1423 1231 18-03-06 MireyaCopeland 9 EsterAcevedo 1424 1445 18-03-07 MireyaCopeland 10 Homer Powers 1437 518 18-03-15 MireyaCopeland 11 TamekaFisher 1468 3 18-03-27 MireyaCopeland 12 Hayden Cross 1473 302 18-03-30 MireyaCopeland 13 WilliemaeHolloway 1497 31 18-04-06 MireyaCopeland 14 ZinaBonner 81 18-04-06 MireyaCopeland 15 Luz House 1499 120 18-04-06 MireyaCopeland M: vairarenaland 1498 10 01.avnaal 1CAA 227 10 Ano
Part-B) 7 points 1) List all the customers names who ordered from store_id=2 (2 points) 2) List all staff names with discount > 0.05 Note: required reference to multiple tables (2 points) 3) Show your system privileges (1 point) 4) write the query to provide system and object privileges to the users (1 point) 5) Write a query to generate roles with five privileges. (1 point)