Create a query in Query Design view based on the Events table. Add the following

Question

Create a query in Query Design view based on the Events table. Add the following fields to the design grid in the order given: Event ID and Rental Fee. Sort the records in ascending order by the Event ID field. In the third column of the design grid, create a new field named Alumni Donation that will calculate and display the donation amount when the Alumni Association donates an amount equal to 10 percent (0.1) of each rental fee amount. Run the query (the first record—EVENT-1244—has an Alumni Donation of 150).

Explanation / Answer

To create Table

CREATE TABLE events_table
(
Event_Id int,
Rental_Fee float
);

sorting the table
SELECT * FROM events_table sort order by Event_Id;

ALTER TABLE events_table ADD Alumni float;

UPDATE events_table
SET Alumni = 0.1*Rental_Fee

Inserting a record

INSERT into events_table VALUES ('1224','1500','150');

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

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