Using mysql statemnts to answer these questions in bullet points: no need to cre

Question

Using mysql statemnts to answer these questions in bullet points: no need to create prgram, Just typed out statements.

Customer, Stove, Registration, Stove-Repairs . Select all the data in each of the four ABC tables. i.e Customers, Stove, Registration and Stove-Repairs. List the SerialNumber and Date of all registrations in the year 2018. List the SerialNumber and Date of all registrations in February. Use the underscore Determine the maximum cost of a stove repair. Count all Stoves. Count all Stoves of each type and display the Type and count. List names, e-mails addresses, and registration date of all customers registration. Two (2) tables involved. .

Explanation / Answer

Answer)

Table Structure is needed for the questions to be answered correctly.

Selecting all the values from the tables:

select * from Customers;

select * from Stove;

select * from Registration;

select * from Stove-Repairs;

Selecting from Registration where the year = 2018

select SerialNumber, Date from Registration where EXTRACT(Year FROM Date)=2018;

Selecting from Registration where the month = February

select SerialNumber, Date from Registration where

EXTRACT(MONTH FROM Date)=2;

Selecting the max cost of Stove Repair:

select max(cost) from Stove-Repairs;

Counting number of Stoves:

select count(*) from Stoves;

select name, email_address, registration_date from Registration;

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

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