Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Power Bi And Azure Integrating Cloud Analytics For Scalable Solutions

Authors: Kiet Huynh

1st Edition

B0CMHKB85L, 979-8868959943

More Books

Students also viewed these Databases questions