Josh Otwell J2112O

## logical_and.sql
SELECT *
FROM category
WHERE category_id = 2
AND
name = 'Comedy';

## simple_select.sql
SELECT *
FROM category
WHERE category_id = 2
AND
name = 'Animation';

## multiple_and.sql
SELECT *
FROM category
WHERE category_id = 2
AND
name = 'Animation'
AND
DATE(last_update) = '2006-02-15';

## where_false.sql
SELECT *
FROM category
WHERE category_id = 2
AND
name = 'Animation'
AND
DATE(last_update) = '2006-02-14'; -- oops, different day

## alter_table_multiple.sql
ALTER TABLE a_tab
ADD COLUMN (
name_col VARCHAR(30) DEFAULT 'not sure',
age_col INTEGER DEFAULT NULL,
another_col TEXT
);

## concat_4_params.sql
SELECT CONCAT('And the winner is: ', first_name,' ', last_name) AS full_name
FROM actor
LIMIT 5;

## concat_try.sql
SELECT CONCAT(first_name,' ', last_name) AS full_name
FROM actor
LIMIT 5;

## first_concat.sql
SELECT CONCAT(first_name, last_name) AS full_name
FROM actor
LIMIT 5;

## novel_attempt.sql
SELECT first_name, ' ', last_name
FROM actor
LIMIT 5;

## concat_error.sql
SELECT CONCAT() AS full_name FROM actor LIMIT 5; Error Code: 1582. Incorrect parameter count in the call to native function 'CONCAT'
	SELECT *
	FROM category
	WHERE category_id = 2
	AND
	name = 'Comedy';
	ALTER TABLE a_tab
	ADD COLUMN (
	name_col VARCHAR(30) DEFAULT 'not sure',
	age_col INTEGER DEFAULT NULL,
	another_col TEXT
	);
	SELECT CONCAT('And the winner is: ', first_name,' ', last_name) AS full_name
	FROM actor
	LIMIT 5;
	SELECT CONCAT(first_name,' ', last_name) AS full_name
	FROM actor
	LIMIT 5;
	SELECT CONCAT(first_name, last_name) AS full_name
	FROM actor
	LIMIT 5;