Guest User

Untitled

a guest
Apr 30th, 2021
290
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.41 KB | None | 0 0
  1. select distinct
  2.     N.personId /* tab and line break for each column */
  3.     , N.primaryName
  4.     , 2020-N.birthYear as AGE
  5.     , N.primaryProfession
  6.     , P.originalTitle
  7. from IMDB_EXPLORE.NAME_BASICS_PIV N
  8.     join IMDB_EXPLORE.TITLE_PIV P /* tab for join*/
  9.         on P.titleId=N.known_for_movieid /* tab for on clause */
  10. where N.personId='nm0005154';
  11. /* I usually tab in my where clause logic as well */
Advertisement
Add Comment
Please, Sign In to add comment