Question: Write a single SQL query to show the number of persons which live in Alabama or Maine. Use abbreviatio n AL for Alabama and ME
Write a single SQL query to show the number of persons which live in "Alabama" or "Maine". Use abbreviatio n "AL" for "Alabama" and "ME" for "Maint person person I INT first name VARCUR(45) laste VARCHWR(45) sex VARCHAR(1) dob DATETIME address Id INT Indexes PRIMARY FK PERSON ADORESS IDX address address Id INT street1 VARCHAR(45) stroet2 VARCHAR(45) city VARCHAR(45) ZIP VARCHAR(5) state id INI state state id INT name VARCHAR(45) abb VARCHAR(2) Is PRIMARY abb_UNIQUE PRIMARY FK ADDRESS STATE IDX
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
