Answered step by step
Verified Expert Solution
Question
1 Approved Answer
DATABASE SYSTEMS: TAL Distributors Exercises. Write in computer and output screenshot. Please give me query and output. 1. List the complete Item table. 2. List
DATABASE SYSTEMS: TAL Distributors Exercises.
Write in computer and output screenshot.
Please give me query and output.
1. List the complete Item table.
2. List the number and name of every customer represented by rep 15.
3. List the number and name of all customers that are represented by rep 15 or that have credit limits of $10,000.
Rep on Rate $23,457.50 0.06 $41,317.00 0.08 $27,789.25 0.06 0.00 0.06 Street 724 Vinca Dr. RepNum LastName Grove CA 90092 CamposRafael Gradey Megan 632 Liatris St. Fullton CA 90085 1785 Tyler Ave. Northfield CA 90098 SeftonJanet 267 Oakley St. Congaree CA 90097 Customer State PostalCode Balance CreditLimitRepNum 28 Laketon St. Toys Galore Brookings Direct CA 90085 CA 90092 The Everything 342 Magee St. CongareeCA 90097 Northfield CA 90098 $1,210.25 $7,500.00 15 $575.00 $10,000.00 30 $2,345.75 $7,500.00 45 126 452 Columbus Dr. Grove 334 386 Johnson's 124 Main St $879.25 $7,500.00 30 3456 Central Ave. Fullton CA 90085 $345.00 $5,000.00 45 Museum Store Cards and More 167 Hale St CA 90104 3345 Devon Ave.Almondton CA 90125 CA 90092 12 Rising Sun Ave. Congaree CA 90097 90098 CA 90104 CA 90085 $5,025.75 $5,000.00 15 $3,456.75 $15,000.00 45 $678.90 $7,500.00 30 $4,234.60 $10,000.00 15 $124.75 $7,500.00 45 $2,475.99 $15,000.00 30 935.75 $7,500.00 15 586 General Store Cricket Gift Shop 372 Oxford St. Grove Cress Store Unique Gifts 786 Passmore St. Northfield Kline's All Season Gifts 382 Wildwood Ave Fullton CA 945 Gilham St. Mesa 893
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started