Sports and Recreation Ahmadabad

-

Hi guys, today I am analyzed a dataset on "Sports and Recreation Ahmadabad". This dataset is about Sports Complexes and Skatting Rinks in Ahmadabad. Based on this dataset we can analyse that How many Sports Complexes and Skatting Rinks are presented in different areas in Ahmadabad? Here, we can observe that mostly sports complexes are presented in Ahmadabad compared to Skatting Rinks. By observing this we can think that why mostly sports complexes are high that too in Raipur and Pushpkunj  each have 2 Sport complexes. May be people liked to go rather than skatting Rinks . And mostly these are in the evening times are open because everyone have free time in evening. Based on these things if they want to open new sports related sports Complex Or skatting rinks they have collect these types of data and they analysed which one gives more profit. And which place they will open new sport complex etc. Or if they have improve the existed once they have to look on how people are going there/ attend there and how many  types of sports played there etc. If thay have improve existed one then they will take parameters like cost, attended people, events, how many different types of sports can play there etc. 





Comments

Post a Comment

Popular posts from this blog

SQL Queries

-
 Hello guys! Today, I practiced SQL Queries in  SQLZoo . SELECT population FROM world WHERE name = 'Germany' SELECT name, population FROM world WHERE name IN ('Sweden', 'Norway','Denmark') SELECT name, area FROM world WHERE area BETWEEN 200000 AND 250000; SELECT name FROM world WHERE population >= 200000000 SELECT name,(population/1000000) as population FROM world WHERE continent='South America' SELECT name,population FROM world WHERE name IN('France', 'Germany', 'Italy') SELECT name FROM world WHERE name LIKE 'United%' SELECT name, population, area FROM world WHERE area>3000000 AND population>250000000
Read more

SQL Queries

-
Image
use sql_store; Select * from customers; insert into customers values (default,'Janani','P',null,null,'RVS','MPL','AP',default); insert into customers values (default,'Lalitha','V',null,null,'MPL','MPL','AP',570), (default,'Vyshu','V',null,null,'Kadapa','Kadapa','AP',670), (default,'Sandhya','G',null,null,'GVP','MPL','AP',590); select * from products; insert into products values (default,'Appliances-Fans',30,5.30), (default,'Appliances-Kettles',35,4.63);
Read more

SQL Queries

-
Hello guys! Today, I practiced SQL Queries in  SQLZoo SELECT SUM(population) FROM world SELECT DISTINCT(continent) FROM world SELECT SUM(gdp) FROM world WHERE continent='Africa' SELECT COUNT(name) FROM world WHERE area>=1000000 SELECT SUM(population) FROM world WHERE name IN('Estonia', 'Latvia', 'Lithuania') SELECT continent,COUNT(name) FROM world GROUP BY continent SELECT continent,COUNT(name) FROM world WHERE population>=10000000 GROUP BY continent SELECT continent FROM world GROUP BY continent HAVING SUM(population)>=100000000
Read more