SQL Query Order of Operations

code-1.sql

FROM
	contact c
INNER JOIN
	display_status d
ON
	(
			c.display_status_id = d.id
		AND
			d.is_active = 1
		AND
			d.is_viewable = 1 
	)

code-2.sql

SELECT
	( 'foo' ) AS bar