1. Run query that converts the uppercase names in a database into normal case (i

Question

1. Run query that converts the uppercase names in a database into normal case (i.e. JERRY JACK becomes Jerry Jack).

2. Run a query that reports back the average of each exam in the same query.

3. Run a query that gives the average grade on the final exam for male students and for female students. Round that number to 1 decimal place only.

4. Run a query or multiple queries if needed to report on final exam average based on the student’s age. Give an average for all students 40 and below and an average for all students over 40. This report will be used continuously so you cannot just figure out what 40 years ago today was. You need to use the date to calculate their age somewhere in your solution.

5. Classify students according to the total number of hours they have completed.

6. Curve the final exam grades 14 points and rank students from 1 to 50 with 1 being the highest score and 50 (being the lowest). The rank must appear in the output.

7. The professor needs to compare the average on the final exam of students who have taken BCIS 3333 and see if it is higher than the class average. Run a query or queries to accomplish this task.

Explanation / Answer

1.

SELECT LOWER(CustomerName) AS UppercaseCustomerName

FROM Customers;

2.

SELECT subject,avg(mark ) as avg_mark FROM 'student' GROUP BY subject

Here i assume that your table name is student.

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

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