text: ---
  date: 2017-12-22T11:48:56-05:00
  title: "More Basic Queries"
  seo_title: "More Basic Queries | SQL | GOUP"
  subheader:
       greeting: SQL - Database Programming Language
       description: This course covers the basics of working with SQL. Work your way through the videos/articles and I'll teach you everything you need to know to interact with database management systems and create powerful relational databases!
  description: This tutorial covers more basic queries in SQL.
  author: GOUP
  image: more-basic-queries.png
  video: LCVK_I5OlY8
  url: /databases/sql/more-basic-queries/
  weight: 13
  ---
  
  ## Code
  
  {{< code lang="sql" >}}
  -- Find all employees
  SELECT *
  FROM employee;
  
  -- Find all clients
  SELECT *
  FROM clients;
  
  -- Find all employees ordered by salary
  SELECT *
  from employee
  ORDER BY salary ASC/DESC;
  
  -- Find all employees ordered by sex then name
  SELECT *
  from employee
  ORDER BY sex, name;
  
  -- Find the first 5 employees in the table
  SELECT *
  from employee
  LIMIT 5;
  
  -- Find the first and last names of all employees
  SELECT first_name, employee.last_name
  FROM employee;
  
  -- Find the forename and surnames names of all employees
  SELECT first_name AS forename, employee.last_name AS surname
  FROM employee;
  
  -- Find out all the different genders
  SELECT DISCINCT sex
  FROM employee;
  
  -- Find all male employees
  SELECT *
  FROM employee
  WHERE sex = 'M';
  
  -- Find all employees at branch 2
  SELECT *
  FROM employee
  WHERE branch_id = 2;
  
  -- Find all employee's id's and names who were born after 1969
  SELECT emp_id, first_name, last_name
  FROM employee
  WHERE birth_day >= 1970-01-01;
  
  -- Find all female employees at branch 2
  SELECT *
  FROM employee
  WHERE branch_id = 2 AND sex = 'F';
  
  -- Find all employees who are female & born after 1969 or who make over 80000
  SELECT *
  FROM employee
  WHERE (birth_day >= '1970-01-01' AND sex = 'F') OR salary > 80000;
  
  -- Find all employees born between 1970 and 1975
  SELECT *
  FROM employee
  WHERE birth_day BETWEEN '1970-01-01' AND '1975-01-01';
  
  -- Find all employees named Jim, Michael, Johnny or David
  SELECT *
  FROM employee
  WHERE first_name IN ('Jim', 'Michael', 'Johnny', 'David');
  
  {{< /code >}}
  
  