Answer to Question #106231 in Databases | SQL | Oracle | MS Access for Brandon Rozzi

Question

1. In the Sales Orders database, make a mailing list of customers who ordered bikes in March 2018. Include a Type column that says Customer. Make sure each distinct customer only appears once. (9 rows)

Answer 1

The answer of the given question will be as per the below

SELECT DISTINCT email_id FROM `customer`
WHERE order_date<2020-12-02 AND
order_date>2020-12-02