order_by_exercises.sql

/*Code from where clause exercises */
use employees;

select * from employees
where first_name in ('Irena', 'Vidya', 'Maya');

select * from employees
where first_name like 'E%';

select count(*) from employees
where hire_date between '1990-01-01' and '1999-12-31';

select * from employees
where birth_date like '%-12-25';

select * from employees
where last_name like '%q%';

select * from employees
where first_name = 'Irena' or  first_name = 'Vidya' or first_name = 'Maya';

select * from employees
where gender = 'M'
AND (first_name = 'Irena' or  first_name = 'Vidya' or first_name = 'Maya');

select * from employees
where last_name like '%E' or last_name like 'E%';

select * from employees
where last_name like '%E' and last_name like 'E%';

select * from employees
where birth_date like '%-12-25'
and hire_date between '1990-01-01' and '1999-12-31';

select * from employees
where last_name like '%q%'
and last_name not like '%qu%'

/* Order By Exercise Answers */

use employees;

select * from employees
where first_name in ('Irena', 'Vidya', 'Maya')
order by first_name;

select * from employees
where first_name in ('Irena', 'Vidya', 'Maya')
order by first_name, last_name;

select * from employees
where first_name in ('Irena', 'Vidya', 'Maya')
order by last_name, first_name;

select * from employees
where first_name like 'E%'
order by emp_no;

select * from employees
where last_name like '%E' or last_name like 'E%'
order by emp_no;

select * from employees
where last_name like '%E' and last_name like 'E%'
order by emp_no;

select * from employees
where first_name like 'E%'
order by emp_no DESC;

select * from employees
where last_name like '%E' or last_name like 'E%'
order by emp_no DESC;

select * from employees
where last_name like '%E' and last_name like 'E%'
order by emp_no DESC;

select * from employees
where birth_date like '%-12-25'
and hire_date between '1990-01-01' and '1999-12-31'
order by birth_date asc, hire_date desc