#dataanalyst #sqlfordataengineer #education #dataanalytics
Here are My profiles that will definitely help your preparation for data analyst or data engineer roles.
Medium: / mahendraee204
Github: github.com/mah...
Table Create and insert statements:
----------------------------------------------------------
create table cities_population_info(
cityid int primary key,
cityname varchar(20),
population int,
area int
)
insert into cities_population_info values
(1, 'Mumbai', 20411000, 603),
(2, 'Delhi', 16787941, 1484),
(3, 'Bangalore', 8425970, 709),
(4, 'Hyderabad', 6809970, 650),
(5, 'Ahmedabad', 5570585, 464),
(6, 'Chennai', 4646732, 426),
(7, 'Kolkata', 4486679, 185),
(8, 'Surat', 4467797, 326),
(9, 'Pune', 3115431, 331),
(10, 'Jaipur', 3073350, 485),
(11, 'Lucknow', 2817105, 631),
(12, 'Kanpur', 2768057, 403),
(13, 'Nagpur', 2405665, 217),
(14, 'Indore', 1964086, 530),
(15, 'Thane', 1818872, 147),
(16, 'Bhopal', 1798218, null),
(17, 'Visakhapatnam', 1730320, 681),
(18, 'Patna', 1684222, null),
(19, 'Vadodara', 1670806, 300),
(20, 'Ghaziabad', 1648643, null)
8 сен 2024
