Question: Log in to phpMyAdmin and select database premiere and table tickets . Write a query that answers each question below. Submit your SQL statements and
Log in to phpMyAdmin and select database premiere and table tickets. Write a query that answers each question below. Submit your SQL statements and a screen shot of the results. Please make sure that your SQL statements are very clearly legible.
- How many tickets are there?
- What is the total point value for all of the tickets combined?
- What is the lowest ticket point value?
- What is the average ticket point value?
officer_initials points + Options +T+ ticket number license plate Edit 2c Copy Delete 1275 NHY918 You can also edit most values n by double-clicking directly on them. | 1344 TYX666 violation Double Parking AOK Parking on Sidewalk AAR O 1368 FEL632 Lack if License Plates AAR 1399 GBX929 Lack of License Plates BCF 1438 HUK432 Lack of License Plates EZL Parking in Handicap Space Ille APL 1448 RLE108 1500 NPS804 Lack of License Plates ARA o O O O O In 1530 UVF764 Parking on Sidewalk EZJ 1548 EMS303 Lack of License Plates ACN 1565 GHJ593 Parking too close to Railroad AAR O 1571 FEA359 Parking too close to Railroad AZQ 1665 GHW570 Parking too close to Railroad BIB 1696 SRC355 Double Parking ASW Edit : Copy Edit Copy Edit Hi Copy Edit 3 Copy Edit Copy Edit Copy Edit : Copy Edit Copy Edit 3 Copy Edit 3c Copy Edit Hi Copy Edit 3 Copy Edit i Copy Edit Copy Edit : Copy Edit Copy Edit Hi Copy Edit i Copy Edit : Copy Edit Copy Edit Copy Edit Copy Edit - Copy Delete Delete Delete Delete Delete Delete Delete Delete Delete Delete Delete Delete Delete Delete Delete Delete Delete Delete Delete Delete Delete Delete Delete 1751 MMP818 O O O O O Parking on Sidewalk BEL 1864 OUT389 Parking in Handicap Space Ille ARX Parking to close to Railroad AAR 1882 XKK412 1922 DQS421 Parking on Sidewalk ALK 1989 YHZ593 Parking on Sidewalk AJU 2032 AFX497 Parking too close to Railroad AGI O O 2108 EKX026 Parking too close to Railroad AAR 2132 VRY273 Lack of License Plates MQS O 2151 PAW142 Lack of License Plates VRQ 2166 FSM023 HBZ Double Parking Parking on Sidewalk 2173 TML612 EZJ o O 2205 MQF649 Double Parking BHW
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
