$(10$ points$)$ Suppose we have a database with a table, StudentInfo, which contains the following records.

$\backslash$table$[[$FirstName$,$LastName,Credits,YearAdmitted$],[$Tim$,$Roberts,$12,2017],[$John$,$Cooper,$13,2008],[$Lamar$,$Williams,$12,2009],[$Tom$,$Parker,$9,2014],[$Mary$,$Smith,$17,2007],[$Lisa$,$Jones,$5,2010],[$Roger$,$Stanford,$3,2013],[$Michael$,$Jones,$18,2008],[$William$,$Smith,$9,2006]]$

a$)$ List the fields for this table.

b$)$ What is the output $($ie: list the appropriate records$)$ from:

SELECT LastName, YearAdmitted FROM StudentInfo WHERE YearAdmitted $<mtext\; id="EditorElement\_1547060"></mtext><mn\; id="EditorElement\_1547061">2</mn><mn\; id="EditorElement\_1547062">0</mn><mn\; id="EditorElement\_1547063">0</mn><mn\; id="EditorElement\_1547064">9</mn>$ OR YearAdmitted $2014$

c$)$ What is the output $($ie: list the appropriate records$)$ from:

SELECT $*$ FROM StudentInfo WHERE Credits$>=12$ AND YearAdmitted $<mtext\; id="EditorElement\_1546516"></mtext><mn\; id="EditorElement\_1546517">2</mn><mn\; id="EditorElement\_1546518">0</mn><mn\; id="EditorElement\_1546519">0</mn><mn\; id="EditorElement\_1546520">9</mn>$;