brt-h

--Databases and SQL for Data Science with Python: Week 6 Bonus Module: Advanced SQL for Data Engineer (Honors): Final Project: Advanced SQL Techniques

--https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DB0201EN-SkillsNetwork/labs/BonusModule_Coursera_v5/FinalProject_BonusModule.md.html?origin=www.coursera.org

--Q1.1 Using Joins: Write and execute a SQL query to list the school names, community names and average attendance for communities with a hardship index of 98.

SELECT CPS.NAME_OF_SCHOOL, CD.COMMUNITY_AREA_NAME, CPS.AVERAGE_STUDENT_ATTENDANCE
FROM CHICAGO_PUBLIC_SCHOOLS CPS
	JOIN CENSUS_DATA CD
ON CPS.COMMUNITY_AREA_NUMBER = CD.COMMUNITY_AREA_NUMBER

brt-h

--Databases and SQL for Data Science with Python: Week 6 Bonus Module: Advanced SQL for Data Engineer (Honors): Hands-on Lab: Joins

--https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DB0201EN-SkillsNetwork/labs/BonusModule_Coursera_v5/Hands-on-lab-Joins.md.html?origin=www.coursera.org

--Q1 List the case number, type of crime and community area for all crimes in community area number 18.

SELECT CCD.CASE_NUMBER, CCD.PRIMARY_TYPE, CD.COMMUNITY_AREA_NAME
FROM CHICAGO_CRIME_DATA CCD
	INNER JOIN CENSUS_DATA CD ON CCD.COMMUNITY_AREA_NUMBER = CD.COMMUNITY_AREA_NUMBER
WHERE CCD.COMMUNITY_AREA_NUMBER = 18;

brt-h

--Databases and SQL for Data Science with Python: Week 6 Bonus Module: Advanced SQL for Data Engineer (Honors): Hands-on Lab: Joins

--https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DB0201EN-SkillsNetwork/labs/Labs_Coursera_V5/labs/Lab%20-%20Joins/instructional-labs.md.html?origin=www.coursera.org

--This Hands-on Lab requires you to have already completed Hands-on Lab: Create Tables using SQL Scripts and Load Data into Tables

--https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DB0201EN-SkillsNetwork/labs/Labs_Coursera_V5/labs/Lab%20-%20Create%20tables%20using%20SQL%20scripts%20and%20Load%20data%20into%20tables/instructional-labs.md.html

--Q1 Select the names and job start dates of all employees who work for the department number 5.

brt-h

--Databases and SQL for Data Science with Python Week 3 Hands-on Lab: Working with Multiple Tables--

--This Hands-on Lab requires you to have already completed Hands-on Lab : Create tables using SQL scripts and Load data into tables, link below--

--https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DB0201EN-SkillsNetwork/labs/Labs_Coursera_V5/labs/Lab%20-%20Create%20tables%20using%20SQL%20scripts%20and%20Load%20data%20into%20tables/instructional-labs.md.html--

--syntax for implicit version of CROSS JOIN aka CARTESIAN JOIN statement-
--SELECT column_name(s)
--FROM table1, table2;

brt-h

	--Databases and SQL for Data Science with Python Week 3 Hands-on Lab: Sub-queries and Nested SELECTs--
	
	--This Hands-on Lab requires you to have already completed Hands-on Lab : Create tables using SQL scripts and Load data into tables, link below--
	
	--https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DB0201EN-SkillsNetwork/labs/Labs_Coursera_V5/labs/Lab%20-%20Create%20tables%20using%20SQL%20scripts%20and%20Load%20data%20into%20tables/instructional-labs.md.html--
	
	--Q1 Execute a failing query (i.e. one which gives an error) to retrieve all employees records whose salary is lower than the average salary.--
	
	SELECT *
	FROM EMPLOYEES

brt-h

brt-h

brt-h

brt-h

brt-h