(SQL) Any difference between these query?

any difference you guy?



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!

    • hao do
    • hao_do
    • 9 mths ago
    • Reported - view

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

Like Follow
  • 9 mths agoLast active
  • 2Replies
  • 42Views
  • 2 Following