SQLize Online / PHPize Online  /  SQLtest Online

/*SELECT store_id, CONCAT(last_name, ' ', LEFT(first_name, 1), '.') AS manager, address FROM staff JOIN store s USING(store_id) JOIN address a ON s.address_id=a.address_id -- WHERE address IN (SELECT address FROM (SELECT)) ORDER BY store_id*/ SELECT s.store_id , CONCAT(st.last_name, ' ', SUBSTR(st.first_name, 1, 1), '.') AS manager , address FROM address a JOIN store s ON a.address_id = s.address_id JOIN staff st on s.manager_staff_id = st.staff_id ; show status like 'Last_query_cost';