VidalNat

VidalNat

VidalNat

VidalNat

-- Database used
use Credit_card_fraud

-- To check column names for reference
declare @collist nvarchar(max);
select @collist = STRING_AGG(COLUMN_NAME,',')
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME = 'fraudTrain';
print @collist

VidalNat

VidalNat

VidalNat

-- country based overall data
SELECT location, max(population) as total_population, max(total_cases) as total_confirmed_cases,max(total_deaths) as total_deaths, max(total_cases/population)*100 as percent_infected 
FROM `my-project-vidal.covid19.case_data` 
where continent is not null
group by location
order by percent_infected desc

--continent based overall data
select  continent, max(population) as population, max(total_cases)as total_cases,max(total_deaths) as total_death
FROM `my-project-vidal.covid19.case_data` 

VidalNat

use  My_tasks
-- exec sp_rename 'coffe_shop_sales' ,'coffee_shop_sales';

--making a copy of od original table to do our cleaning & analysis just in case
select * 
into copy_coffee_shop_sales
from dbo.coffee_shop_sales

-- verify the table creation
select * from copy_coffee_shop_sales  order by transaction_id;