Question: 4 . Write an SQL query for each of the following: a . Fetch unique values of DEPARTMENT from the Worker table. b . Print

4. Write an SQL query for each of the following:
a. Fetch unique values of DEPARTMENT from the Worker table.
b. Print all Worker details from the Worker table order by FIRST_NAME Ascending and DEPARTMENT Descending.
c. Show the country name and its area with an area between 200,000 and 250,000 from World table.
d. Select the columns title, rating, and year_released from the table Movies showing only movies that were released before 2001 and had a rating above 9.
e. Show the language and number of movies per each language from table Movies.
f. Show the year released, the language and count of movies sorted by the release date in ascending order from table Movies.
g. Show the languages and the average movie budget by language category showing only the languages with an average budget above $50 million from table Movies.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!