Question 4. Display the cost per day for the theatres that have the name ending with ‘t’. Display the theatre name and cost per day in ascending order of the cost per day.

Question 4                                                                                                                   2 Marks

Display the cost per day for the theatres that have the name ending with ‘t’. Display the theatre name and cost per day in ascending order of the cost per day.

TheatreName CostPerDay
East $700.00
West $740.00

select t.TheatreName, t.CostPerDay  from Theatre t where TheatreName Like "%t"

Expert's Answer

Hire Expert Tutors

Get Professional Tutoring at Low Price in Australia


Academic Excellence
Professional
Tutoring Services
👥

25k+

Sessions Done

4.9/5

Student Rating

👨‍🏫

600+

Expert Tutors

Why Learn With Us?

🧠

Concept Clarity

🎯

Personalized Plan

💸

Affordable Rates

📅

Flexible Schedule

📈

Results Driven

💬

24/7 Support

You may also like

TOP