AWG_Feasibility_Report_SQL.sql

/****** Script for SelectTopNRows command from SSMS  ******/
use Weather_DATA;
SELECT TOP (1000) [name]
      ,[datetime]
      ,[tempmax]
      ,[tempmin]
      ,[temp]
      ,[dew]
      ,[humidity]
      ,[icon]
  FROM [Weather_DATA].[dbo].[Lahore ]

  select count(icon) as Total_Days_of_Rain from 
  [Lahore] where icon = 'rain';                                                        /* To verify the number of rainy days should be less than 100 */

  select * into updated_table_3 from [Lahore ] 
  where dew > 0  and humidity > 0 and temp> 0 and icon not like 'rain';                /* Seperated the required data */

  alter table updated_table_3 alter column dew int; 

  select datetime, name, humidity, temp, dew, Province into updated_table_4 
  from updated_table_3 left join location_table on name = location;                    /* to match the table of values and province */ 

  select * from updated_table_4;