-- If you want to modify the changes I did to the table (adding the sales_date), 
--please execute this code which will drop the table you created previously and recreate it with the correct fields and values
DROP TABLE Employee

CREATE TABLE Employee (
EmployeeID int,
FirstName varchar(50),
LastName varchar(50),
Region varchar(50),
Sales int,
Sales_Date DATE
)


INSERT INTO Employee VALUES
(1, 'John', 'Doe', 'North', 12, '2023-01-06'),
(2, 'Jane', 'Smith', 'South', 15, '2023-02-06'),
(3, 'Michael', 'Johnson', 'East', 18, '2023-03-22'),
(4, 'Emily', 'Davis', 'West', 17, '2023-02-18'),
(5, 'Chris', 'Brown', 'North', 13, '2023-03-30'),
(6, 'Jessica', 'Wilson', 'South', 14, '2023-07-24'),
(7, 'David', 'Taylor', 'East', 16, '2023-08-02'),
(8, 'Sarah', 'Moore', 'West', 19, '2023-08-31'),
(9, 'Daniel', 'Anderson', 'North', 11, '2023-08-31'),
(10, 'Laura', 'Jackson', 'South', 20, '2023-02-18');


SELECT *
FROM Employee
----------------------------------------------------------------------------------------------------------------------------

/* WHERE clause
	Comparison Operators:
		'>'				Greater than
		'>='			Greater than or Equal to
		'<'				Lower than
		'<='			Lower than or Equal to
		'='				Equal to
		'!=' or '<>'	Not Equal To
*/


SELECT *
FROM Employee

SELECT *
FROM Employee
WHERE Sales >= 16

SELECT *
FROM Employee
WHERE Sales_Date = '2023-03-22'

SELECT *
FROM Employee
WHERE FirstName = 'John'

---------------------------------------------------------------------------------------------------------

/* WHERE clause
	Pattern Matching Operator:
		'LIKE':
			'%'		Zero, One or multiple characters
			'_'		Just one single character
*/


SELECT *
FROM Employee

SELECT *
FROM Employee
WHERE FirstName LIKE 'J%'

SELECT *
FROM Employee
WHERE FirstName LIKE '_a%'
---------------------------------------------------------------------------------------------------------

/* WHERE clause
	Logical Operators:
		'AND'
		'OR'
		'NOT'
*/


SELECT *
FROM Employee

SELECT *
FROM Employee
WHERE FirstName LIKE 'j%' OR NOT Sales > 13