Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select distinct
- N.personId /* tab and line break for each column */
- , N.primaryName
- , 2020-N.birthYear as AGE
- , N.primaryProfession
- , P.originalTitle
- from IMDB_EXPLORE.NAME_BASICS_PIV N
- join IMDB_EXPLORE.TITLE_PIV P /* tab for join*/
- on P.titleId=N.known_for_movieid /* tab for on clause */
- where N.personId='nm0005154';
- /* I usually tab in my where clause logic as well */
Advertisement
Add Comment
Please, Sign In to add comment