Display the total ticket sales to males

Assignment Help Computer Engineering

Reference no: EM132163018

Use the Week 7 Assignment Database File for this section of the assignment

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.

Reference no: EM132163018

Questions Cloud

Why do we need groups for user management : What are the three files mentioned in this chapter that contain information about a user's account and the user's group?

Write a program that wihtout the use of boolean variable : Using C++ microsoft visual studios write a program that wihtout the use of boolean variable allows the user to enter a integer.

Tax expenditure affect the public budget : Explain why a tax expenditure can be thought of as off-budget. How, precisely, does a tax expenditure affect the public budget?

Design a new website and you are interviewing : Explain how your questions help you understand how they navigate the sides and have the styling impacts their experience.

Display the total ticket sales to males : 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.

Write a select statement that returns four columns : Write a select statement that returns four columns based on the InvoiceTotal column of the invoices table, AP database.

What is the total surplus with the ceiling price : When the government imposes a price ceiling 12$, disequilibrium between quantity demanded and quantity supplied results in what?

Output and consumption of the good : Explain why a competitive market would generally lead to too much output and consumption of the good if production of the good generates a negative externality.

Life of how a change in the market : Think of a relevant example in your own life of how a change in the market

User Account

All Pages