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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!