DATABASE SYSTEMS: TAL Distributors Exercises.

Write in computer and output screenshot.

Please give me query and output.

1. List the descriptions of all items in category GME and that are located in storehouse number 3.

2. List the order numbers for orders placed by customer number 586 on October 15, 2015.

3. List the name of each customer that placed an order for two different items in the same order.

Rep RepNum Las State PostalCode CA 90092 City Rate $23,457.50 0.06 $41,317.00 0.08 1785 Tyler Ave. Northfield CA 90098 S27,789.25 0.06 s0.00 0.06 FirstName Street Campos Rafael724 Vinca Dr. Grove Gradey Megan 63 Liatris St. Fullton CA 90085 Tian 2 2 45 Hui SeftonJanet267 Oakley St. Congaree CA 90097 Customer CustomerNum CustomerName Street 126 260 334 Toys Galore Brookings Direct The Everything 28 Laketon St. 452 Columbus Dr.Grove 342 Magee St. Congaree State PostalCode Balance CreditLimit RepNum CA 90085 CA 90092 CA $1,210.25 $7,500.00 15 $575.00 $10,000.00 30 $2,345.75 $7,500.00 45 90097 124 Main St Northfield CA 90098 Johnson's Department Store $879.25 $7,500.00 30 3456 Central Ave. Fulltorn CA 90085 345.00$5,000.00 45 Historical Museum Store Cards and More $5,025.75 $5,000.005 $3,456.75 $15,000.00 45 $678.90 $7,500.00 30 12 Rising Sun Ave. Congaree CA 90097 $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 CA 90104 3345 Devon Ave. Almondton CA 90125 CA 90092 167 Hale St. 586 General Store Cricket Gift Shop 372 Oxford St. Cress Store Unique Gifts 786 Passmore St. Kline's All Season Gifts 382 Wildwood Ave, Grove Northfield CA 90098 CA 90104 945 Gilham St.Mesa 893 Fulton