Question

1 Approved Answer

Posted on Sep 25, 2024

TAL SQL Views - 1 (Games) Using the TAL database, create a SQL view based on the following scenario: Francesca is interested in the item

TAL SQL Views - 1 (Games) Using the TAL database, create a SQL view based on the following scenario: Francesca is interested in the item number, description, units of hand, and unit price for TAL Distributors items that are in category GME. Name the View Games. Create a SQL View in MySQL. Submit a screenshot of your statement. Make sure I can see the view listed in the Navigator Pane in the TAL Views subfolder.

TAL SQL Views - 2 (RepCust) Using the TAL database, create a SQL view based on the following scenario: Francesca needs to know the number and name of each rep, along with the number and name of the customer represented by each rep. Create a singe table that contains the rep number, rep name, customer number and customer name. Name the view RepCust. Create a SQL View in MySQL. Submit a screenshot of your statement. Make sure I can see the view listed in the Navigator Pane in the TAL Views subfolder.

TAL SQL - Query View 2A (RepCust) Create a query based on the REPCUST view and the following scenario. Suppose, Megan wants to know the name of the rep for customer 260. Submit a screenshot of your statement. Make sure I can see the query statement and table output in the result grid.

TAL SQL - Query View 2B (RepCust) Create a query based on the REPCUST view and the following scenario. Suppose, Megan wants to create a list of reps by customer names alphabetically. Submit a screenshot of your statement. Make sure I can see the query statement and table output in the result grid.

TAL SQL - Query View 1 (Games) Create a query based on the GAMES view and the following scenario. Suppose, Francesca wants to know which games have a quantity of 25 or less in stock. Submit a screenshot of your statement. Make sure I can see the query statement and table output in the result grid.

image text in transcribed

Repo RepNurm Last Name First Name Street City State PostalCode Commission Rate Rafael 724 Vinca Dr. Grove CA 900092 $23,457.50 0.06 $41,317.00 0.08 15 Gradey Megan 632 Liatris St. Fulton CA 90085 30 Tian 1785 Tyler Ave. Northfield CA 90098 $27,789.25 0.06 45 Janet 267 Oakley St. CA $0.00 60 90097 0.06 Customer CustomerNum CustomerName Street City State PostalCode Balance Creditlimit RepN Toys Galore 28 Laketon St. Fulton $1,210.25 $7,500.00 15 126 Brookings Direct 452 Columbus Dr. Grove CA 90092 $575.00 $10,000.00 30 260 The Everything 342 Magee St. Congaree CA 90097 $2,345.75 $7,500.00 45 Shop 124 Main St. Northfield CA 90098 386 $879.25 $7,500.00 30 Store 3456 Central Ave. Fullton 90085 S345.00 $5,000.00 45 440 Historical Museum Store Cards and More 167 Hale St. 90104 $5,025.75 $5,000.00 15 Almondton Devon A General Store 3345 $3,456.75 $15,000.00 45 586 Cricket Gift Shop 372 Oxford St. Grove CA 90092 665 $678.90 $7,500.00 30 Cross Store 12 Rising Sun Ave. Congaroe $4,234.60 $10,000.00 15 Unique Gifts 786 Passmore St. Northfield CA 90098 S124,75 $7500.00 45 796 Kline's 945 Gilham St. Mesa $2,475.99 $15,000.00 30 90104 All Season Gifts 382 Wildwood Ave. Fullton $935.75 $7,500.00 15 893 90085 Orders Orderline Order Num Order Date Customer Num Order Nunn Henn Num NumOrdered QuotedPrice 1012/2015 51608 CD33 $86.99 51608 126 1012/2015 KL78 $10.95 51610 334 51610 1013/2015 386 TR40 $13.99 51613 51610 10 1013/2015 DL51 S104.95 51614 2600 51613 1015/2015 S124.95 51617 586 FD11 51614 S115.99 1015/2015 126 51619 51617 1015/2015 586 S116.95 TW35 51623 51617 1016/2015 796 S121.95 51625 FD11 51619 S29.95 DR67 51623 112 S36.95 FH24. 51623 10 $13.10 KD34. 51623 51625 MT03 8 SH5179 tem Item Num Description OnHand Category Storehouse Price AH74. Patience 9 GME $22.99 BR23 Skittles 21 GME $29.99 36 To CD33 Wood Block Set (48 piece) $89.49 12 To I $107.95 DL51 Classic Railway Set 24 PZL DR67 Giant Star Brain Teaser $31.95 I DW23 Mancala 40 GME $50.00 FD11 Rocking Horse 8 TOY $124.95 1 FH24, Puzzle Gift Set 65 PZL $38.95 KA12 Set 56 GME $75.00 KD34 Pentominoes, Brain T 60 PZL $14.95 KL78 Pick Up Sticks 110 GME $10.95 MTo3 Zauberkast Brain Teaser en 45 PZL $45.79 NL89 Wood Block Set (62 piece) 32 TOY $119.75 TR40 Tic Tac Toe 75 GME $13.99 TW35 Fire Engine 30 TOY $118.95 Repo RepNurm Last Name First Name Street City State PostalCode Commission Rate Rafael 724 Vinca Dr. Grove CA 900092 $23,457.50 0.06 $41,317.00 0.08 15 Gradey Megan 632 Liatris St. Fulton CA 90085 30 Tian 1785 Tyler Ave. Northfield CA 90098 $27,789.25 0.06 45 Janet 267 Oakley St. CA $0.00 60 90097 0.06 Customer CustomerNum CustomerName Street City State PostalCode Balance Creditlimit RepN Toys Galore 28 Laketon St. Fulton $1,210.25 $7,500.00 15 126 Brookings Direct 452 Columbus Dr. Grove CA 90092 $575.00 $10,000.00 30 260 The Everything 342 Magee St. Congaree CA 90097 $2,345.75 $7,500.00 45 Shop 124 Main St. Northfield CA 90098 386 $879.25 $7,500.00 30 Store 3456 Central Ave. Fullton 90085 S345.00 $5,000.00 45 440 Historical Museum Store Cards and More 167 Hale St. 90104 $5,025.75 $5,000.00 15 Almondton Devon A General Store 3345 $3,456.75 $15,000.00 45 586 Cricket Gift Shop 372 Oxford St. Grove CA 90092 665 $678.90 $7,500.00 30 Cross Store 12 Rising Sun Ave. Congaroe $4,234.60 $10,000.00 15 Unique Gifts 786 Passmore St. Northfield CA 90098 S124,75 $7500.00 45 796 Kline's 945 Gilham St. Mesa $2,475.99 $15,000.00 30 90104 All Season Gifts 382 Wildwood Ave. Fullton $935.75 $7,500.00 15 893 90085 Orders Orderline Order Num Order Date Customer Num Order Nunn Henn Num NumOrdered QuotedPrice 1012/2015 51608 CD33 $86.99 51608 126 1012/2015 KL78 $10.95 51610 334 51610 1013/2015 386 TR40 $13.99 51613 51610 10 1013/2015 DL51 S104.95 51614 2600 51613 1015/2015 S124.95 51617 586 FD11 51614 S115.99 1015/2015 126 51619 51617 1015/2015 586 S116.95 TW35 51623 51617 1016/2015 796 S121.95 51625 FD11 51619 S29.95 DR67 51623 112 S36.95 FH24. 51623 10 $13.10 KD34. 51623 51625 MT03 8 SH5179 tem Item Num Description OnHand Category Storehouse Price AH74. Patience 9 GME $22.99 BR23 Skittles 21 GME $29.99 36 To CD33 Wood Block Set (48 piece) $89.49 12 To I $107.95 DL51 Classic Railway Set 24 PZL DR67 Giant Star Brain Teaser $31.95 I DW23 Mancala 40 GME $50.00 FD11 Rocking Horse 8 TOY $124.95 1 FH24, Puzzle Gift Set 65 PZL $38.95 KA12 Set 56 GME $75.00 KD34 Pentominoes, Brain T 60 PZL $14.95 KL78 Pick Up Sticks 110 GME $10.95 MTo3 Zauberkast Brain Teaser en 45 PZL $45.79 NL89 Wood Block Set (62 piece) 32 TOY $119.75 TR40 Tic Tac Toe 75 GME $13.99 TW35 Fire Engine 30 TOY $118.95