Skip to content

Instantly share code, notes, and snippets.

@nrogap

nrogap/complex-sql-command.sql

Last active September 8, 2017 01:56
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save nrogap/4162d609348d546fa902435fd97c0915 to your computer and use it in GitHub Desktop.
Save nrogap/4162d609348d546fa902435fd97c0915 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
complex-sql-command.sql
SELECT
student_id,
first_name,
last_name,
CONCAT(first_name,' ',last_name) AS full_name,
FROM person p
INNER JOIN class_room cr
ON p.student_id = cr.student_id
WHERE
cr.class_room_name = '6/1'
AND cr.class_room_builder = 3
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment