DATABASE SYSTEMS: TAL Distributors Exercises.

Write in computer and output screenshot.

Please give me query and output.

1. List all information from the Item table for item FH24.

2. List the order number, order date, customer number, and customer name for each order.

3. List the number and date of all orders that were placed on 10/15/2015 or that were placed by a customer whose rep number is 30.

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