SQL, using "AND"


I’m new to this and i was playing around with the code to see if i could narrow the origin down to show only “SNA” but everything I’ve tried hasn’t worked…


Please remember to include a link to the exercise in new topics relating to a lesson. Thanks.




This came up with two results…

select id, origin from flights f
where f.origin is "SNA";

select id, origin, destination from flights f
where f.origin is "SNA";