SQL INTERVIEW QUESTIONS AND ANSWERS PART 1 | ORACLE SQL | VUZZARE

In this video, we have created a table city and country, inserted values and run the following queries:
1.Fetch all columns from the country table
2.Fetch id and name columns from the city table
3.Fetch city names sorted by the rating column in the default ASCending order
4.Fetch city names sorted by the rating column in the DESCending order
6.Fetch names of cities that have a rating above 3
7.Fetch names of cities that are neither Berlin nor Madrid
8.Fetch names of cities that start with a 'P' or end with an 's'
9.Fetch names of cities that start with any letter followed by 'ublin'
10.Fetch names of cities that have a population between 500K and 5M
11.Fetch names of cities that don't miss a rating value
12.Fetch names of cities that are in countries with IDs 1, 4, 7, or 8
13.INNER JOIN
14.LEFT JOIN
15.RIGHT JOIN
16.FULL JOIN
17.CROSS JOIN
18.NATURAL JOIN
19.Find out the number of cities
20.Find out the number of cities with non-null ratings
21.Find out the number of distinctive country values
22.Find out the smallest and the greatest country populations
23.Find out the total population of cities in respective countries
24.Find out the average rating for cities in respective countries if the average is above 3

---------------------------------------------------------------------------------------------------------
Track: Lost Sky - Dreams pt. II (feat. Sara Skinner) [NCS Release]
Music provided by NoCopyrightSounds.