(SQL) Any difference between these query?

any difference you guy?

 and 

 

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi hao do , the discrepancy here is within the first picture on line 2:
               WHEN school_name < 'n' then 'a-m'
    When you write <'n', you are also taking in all the null values that you see in the second picture (2508). 

    If you have any questions,  please don't hesitate to write into our in-product chat!

    Reply Like
  • Francisco Mosqueda the first pic is Mode tutorial's answer with query name from letter 'A' but return 'null' value. Error right?

    Reply Like
Like Follow
  • 2 wk agoLast active
  • 2Replies
  • 13Views
  • 2 Following