Member Avatar for TheLittleEngine

Provide a list of Students in zip code 11214 that registered more than 2 days after their student record was created.

what i have so far right now i have it where it checks for if created date
after registration date just can't figure out how any points in the right direction

SELECT first_name, last_name, created_date, registration_date
FROM student
WHERE zip = '11214' AND registration_date > created_date;

  • 1 Contributor
  • 1 Reply
  • 69 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by TheLittleEngine
Member Avatar for TheLittleEngine

i'm a dummy i should of worked on it more before posting :/ i +2 the created_date in the where statement

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.