Alignments

• Main keywords in select/insert/delete/update statement

  Left align:

  DELETE FROM job_history jh  
  WHERE  employee_id = (SELECT employee_id  
                        FROM   employee e  
                        WHERE  jh.employee_id = e.employee_id  
                               AND start_date = (SELECT Min(start_date)  
                                                 FROM   job_history jh  
                                                 WHERE  jh.employee_id = e.employee_id)  
                               AND 5 > (SELECT Count( * )  
                                        FROM   job_history jh  
                                        WHERE  jh.employee_id = e.employee_id  
                                        GROUP  BY employee_id  
                                        HAVING Count( * ) >= 4)); 

  INSERT INTO employees 
              (employee_id, 
               first_name, 
               department_id)  
  VALUES     (113, 
              'Louis', 
              100); 
              

  UPDATE employees  
  SET    department_id = 70  
  WHERE  employee_id = 113;  

• Select list

  • Column alias

• Join clause: ON keyword

• Logical condition operator: AND, OR, NOT