Learn Python

Learn Python explains everything you need to know to write python programs

Learn SQL

Learn SQL explains everything you need to learn interms of SQL.

Customers table:

customer_id	first_name	last_name	birth_date	phone	address	city	state	points
1	Babara	MacCaffrey	28-03-1986	781-932-9754	0 Sage Terrace	Waltham	MA	2273
2	Ines	Brushfield	13-04-1986	804-427-9456	14187 Commercial Trail	Hampton	VA	947
3	Freddi	Boagey	07-02-1985	719-724-7869	251 Springs Junction	Colorado Springs	CO	2967
4	Ambur	Roseburgh	14-04-1974	407-231-8017	30 Arapahoe Terrace	Orlando	FL	457
5	Clemmie	Betchley	07-11-1973		5 Spohn Circle	Arlington	TX	3675
6	Elka	Twiddell	04-09-1991	312-480-8498	7 Manley Drive	Chicago	IL	3073
7	Ilene	Dowson	30-08-1964	615-641-4759	50 Lillian Crossing	Nashville	TN	1672
8	Thacher	Naseby	17-07-1993	941-527-3977	538 Mosinee Center	Sarasota	FL	205
9	Romola	Rumgay	23-05-1992	559-181-3744	3520 Ohio Trail	Visalia	CA	1486
10	Levy	Mynett	13-10-1969	404-246-3370	68 Lawn Avenue	Atlanta	GA	796

Orders Table:

order_id	customer_id	order_date	status	comments	shipped_date	shipper_id
1	6	30-01-2019	1
2	7	02-08-2018	2		03-08-2018	4
3	8	01-12-2017	1
4	2	22-01-2017	1
5	5	25-08-2017	2		26-08-2017	3
6	10	18-11-2018	1	Aliquam erat volutpat. In congue.
7	2	22-09-2018	2		23-09-2018	4
8	5	08-06-2018	1	Mauris enim leo, rhoncus sed, vestibulum sit amet, cursus id, turpis.
9	10	05-07-2017	2	Nulla mollis molestie lorem. Quisque ut erat.	06-07-2017	1
10	6	22-04-2018	2		23-04-2018	2

JOINS

Join clause is used to combine two or more tables, based on a relatable column between them