answer quickly Please For the following data, which has been loaded into the IS3

Question

answer quickly Please

For the following data, which has been loaded into the IS331FINAL Access Table, write a query that answers the following question: What are the Student IDs, StudentName, Majorld, Majorname, Credits, Street Address, and Address zip code for any students that have an "S" anywhere in their first or last name? Show all columns in the STUDENT table and be sure to add the Majorname from the Major Table. Use a single letter alias name for the tables. Please note that the wild card character "%" in SQL Server is an "*" in Access. STUDENT

Explanation / Answer

Answer:

Please find the required query as follows:

Select S.StudentID,
S.StuName As StudentName,
   S.Major As MajorId,
   M.MajorName,
   S.Credits,
   S.Address_St AS [Street Address],
   S.Address_Zip As [Address Zip]
From [STUDENT] S INNER JOIN [MAJOR] M ON M.MajorID = S.Major
Where S.StuName like '%S%'

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.