brt-h

brt-h

brt-h

brt-h

brt-h

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

-- Drop the PETRESCUE table in case it exists
drop table PETRESCUE;
-- Create the PETRESCUE table 
create table PETRESCUE (
	ID INTEGER NOT NULL,
	ANIMAL VARCHAR(20),
	QUANTITY INTEGER,
	COST DECIMAL(6,2),
	RESCUEDATE DATE,
	PRIMARY KEY (ID)

brt-h

brt-h