Fоr the lаst three questiоns, we've begun tо use the Student dаtаbase, that we'll use for the rest of the test. Here is a schema diagram for this database: If we are trying to get the information we need "Find the name of every student along with the full name (and not just the short code) of their major", we may try the following query: SELECT SNAME, DNAMEFROM Student, Department_to_major Unfortunately, we would get the wrong answer if we use this query. Why? After explaining why the query above returns the wrong result, write a SELECT FROM WHERE query that returns the correct result.