SQL Queries

select * from employees;

select first_name,last_name

from employees

where last_name like '%a';

select count(last_name) as count_last_name,gender

from employees 

where last_name like '%a'

group by gender;

select count(last_name) as count_last_name,gender

from employees 

where last_name like 'ja%'

group by gender;

select count(last_name) as count_last_name,gender

from employees 

where last_name like 'ja%i'

group by gender;

select count(distinct last_name) as count_last_name,gender

from employees 

where last_name like 'ja%i'

group by gender;

select distinct last_name as unique_names

from employees 

where last_name like 'ja%i';