WRITE A QUERY FOR EACH STATEMENT 1. Write a query to display the student\'s firs

Question

WRITE A QUERY FOR EACH STATEMENT

1. Write a query to display the student's first name, last name, and registration date for all students who have the same Employer as Fred Crocitto. Exclude Fred from the results.

2. Create a query to display the course no and description for all courses that cost more than the average cost. Sort the results in descending order of cost.

3. Write a query that will display the student id and last name for all students who work for an Employer with any student whose first name contains a

Explanation / Answer

1.select firstname ,lastname,reg date from list where company=fred crocitto 2. select courseno,description from cost where cost > avgcost order by cost 4. select s.firstname ,s.last name, s.student id ,e.name from student s , employee e where e.name= Colt Industries 9.select c.description s.cost from course where cost = 350

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

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