SELECT MEMBER_ID, MEMBER_NAME, GENDER, DATE_FORMAT(DATE_OF_BIRTH,'%Y-%m-%d')
FROM MEMBER_PROFILE
WHERE GENDER = 'W'
AND DATE_FORMAT(DATE_OF_BIRTH, '%m') = 03
AND TLNO IS NOT NULL
ORDER BY MEMBER_ID
SELECT P.PRODUCT_CODE, SUM(P.PRICE*OS.SALES_AMOUNT) AS SALES
FROM OFFLINE_SALE OS
INNER JOIN PRODUCT P ON P.PRODUCT_ID = OS.PRODUCT_ID
GROUP BY P.PRODUCT_CODE
ORDER BY SUM(P.PRICE*OS.SALES_AMOUNT) DESC, P.PRODUCT_CODE