Write a query to sort out those customers with all information whose I'd value is within any of 3007,3008 and 3009

Question

Sql

Answer 1

Pauline are you using two tables or just one table for fetching the record in case you using two tables then you can use subquery with groupby and orderby or join

SELECT * FROM customer WHERE customer_id IN (3007,3008,3009);

Or
SELECT * FROM CUSTOMER
WHERE CUSTOMER_ID BETWEEN 3007 AND 3009;

Answer 2

Pauline It seems your question appears to be an assignment. Please show us your attempt and use the 8 rules to get help from the community.
https://www.sololearn.com/Blog/38/8-simple-rules-to-get-help-from-the-community

*can be a code coach solution which is meant for you to do to help you establish your skills abilities and where you need to learn... not the community
*one issued by a school or other institution
*one issued or created by another platform
*one that appears to be in the form of a challenge that was created by you or somewhere else.

Your question will be reviewed by a team of moderators and will most likely be marked for deletion.
https://www.sololearn.com/Discuss/1316935/?ref=app