SQL – Select 3rd & 4th Year Students
student is a database table containing student details whose create DDL is given below. Write the SQL to list students belonging to third and…
SQL – Top Revenue Grossed By Year In Movies
movie is a database table containing movie details whose create DDL is given below. The revenue of the movie is in millions. Write the SQL to…
SQL – Students with Total Marks More Than 50
student is a database table containing student details whose create DDL is given below. marks is a database table containing the total marks…
SQL – Employee Name Search
employee is a database table containing employee details whose create DDL is given below. Write the SQL to list the name and designation of…
Weather Observation Station 4
Find the difference between the total number of CITY entries in the table and the number of distinct CITY entries in the…
Weather Observation Station 1
Query a list of CITY and STATE from the STATION table.The STATION table is described as follows:…
Japanese Cities’ Attributes
Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN. The CITY table is…
Revising the Select Query I
Query all columns for all American cities in the CITY table with populations larger than 100000. The CountryCode for…
Weather Observation Station 3
Query a list of CITY names from STATION for cities that have an even ID number. Print the results in any order,…
Select All
Query all columns (attributes) for every row in the CITY table. The CITY table is described as follows: