1) Analyses of a Online Book Store.
A. Find out the frequency of books published each year. (Hint: Sample dataset will be provided).
B. Find out in which year maximum number of books were published.
C. Find out how many books were published based on ranking in the year 2002.
Sample Dataset Description.
The Book-Crossing dataset consists of 3 tables that will be provided to you.
2) Airlines Analysis.
A. Find list of Airports operating in the Country India.
B. Find the list of Airlines having zero stops.
C. List of Airlines operating with code share.
D. Which country (or) territory having highest Airports.
E. Find the list of Active Airlines in United state.
Sample Dataset Description.
In this use case, there are 3 data sets.
- Final_airlines.
- Routes.dat.
- Airports_mod.dat.