• Learn
    • Courses
    • Career Tracks
    • Upcoming Courses
  • Certificates
    • Career Track Certificate
    • Course Certificate
  • Resources
    • All Resources
    • Course Notes
    • Templates
    • Infographics
    • Career Guides
    • Practice Exams
    • Blog
    • Success Stories
  • Pricing
  • Business
    • Team Plan
    • Live Trainings
Log In Sign Up
Follow this topic
Share
data learner
Last answered:

07 Nov 2021

Posted on:

27 Oct 2021

0

why removing where gives 12 rows and if we add where hire_date > "1999-01-01" we get 800+ results?

in SQL / WHERE vs HAVING - Part II
1 answers ( 0 marked as helpful)
Martin Ganchev
Instructor
Posted on:

07 Nov 2021

0

Submit an answer

related questions

Islam Elkhateeb
1
24
Resolved: can't add row, I do may trail and it all back with errors
Alessandro Imbrìaco
2
22
Resolved: Explanations to questions 15 and 29
Marcus Wern Han Leong
2
16
Why did you not do not null, primary key and auto increment for customer id in the solution?
Matt Birch
1
10
No rows in employees database
hazem gamal
0
10
Resolved: i always retrieve 36 rows !!
Hasan Arda Burhan
3
8
When will you add English subtitles?
Nourhan Osama Ahmad
0
8
how to upload the assignment and remark on it 
Maxime Darbouze
0
8
I wrote the same command that is the sql file and it did not work

All the Data Science Courses You Need

About

  • About Us
  • Instructors
  • Contact Us
  • Pricing

Learn

  • Courses
  • Career tracks
  • Career Certificate
  • Course Certificate

Resources

  • Course Notes
  • Templates
  • Career Guides
  • Practice exams
  • Blog

Platform

  • Success stories
  • Q&A Hub
  • Help Center
  • Verify Certificate
© 2023 365 Data Science. All Rights Reserved.
Terms of Use Privacy Policy Cookies