please make sure to answer wIth pictures thanks! after looking at this table ple

Question

please make sure to answer wIth pictures

thanks!

after looking at this table please answer the question

Create and save a data entry form to input more records into the table. Use the form to add 10 more records and save the database with the extra records. Create SQL queries to do the following:

Display the total ticket sales to males

Display each event (only once) in all upper-case letters

Display the total number (not $ amount) of sales of Rodeo tickets

Save all 3 queries.

Finally, export the entire table to an Excel spreadsheet and save it. Submit the database file with your form, the records you added and your queries, and also submit your Excel file.

Explanation / Answer

1. Select count(*) from ArenaTicketSales where Gender='M';

2. Select DISTINCT UCASE(Event) from ArenaTicketSales;

3. Select count(*) from ArenaTicketSales where Event='Rodeo';

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.