how to select date by day of week in sql code example

Example: extract weekday from date in sql

SELECT WEEKDAY(date);