NEED HELP WITH THIS HOMEWORK PROBLEM USING ACCESS IN COMPUTER PROGRAMMING CLASS
ID: 3684496 • Letter: N
Question
NEED HELP WITH THIS HOMEWORK PROBLEM USING ACCESS IN COMPUTER PROGRAMMING CLASS
Setion Type 1) Show first and last name and salary of faculty members who earn more than $80000 a year 2) Show all columns (in tblfaculty) of faculty members earning more than $80000 a year in a descending order of the salary. 3) Show all columns of faculty members earning more than $80000 a year in an ascending order of facultyID. 4) Show all FacultylDs and SectionIDs the faculty member teaches. 5) Show TOP 30 faculty records (all columns) in terms of their Joining Date (recently joined faculty members). Hint: SELECT TOP 30 6) Show Name, StudentID, DeptID, Email address, and Date-of-birth of freshman students in ISE department. List them by descending order of their names 7) Show only distinct Designation (Position) of FacultyExplanation / Answer
1) select fname, lname from table where salary>80000.
2)SELECT column_name, column_name,.......
FROM table_name where salary>80000
ORDER BY salary DESC
3)SELECT column_name, column_name,.......
FROM table_name where salary>80000
ORDER BY facultyID ASC
4) select FacultyId, SectionId from teaches
5)SELECT column_name, column_name,.......
FROM table_name
ORDER BY JoiningDate DESC LIMIT 30
6) SELECT cStudentId, DeptId, email address, DateOfBirth
FROM freshman ISE
ORDER BY name DESC
7)SELECT DISTINCT facultyposition
FROM Faculty;
8)SELECT facultyid,courseid,evaluationresult
FROM Courses where year=1999 AND evaluationscore>90
9)SELECT sectionId, DeptId
FROM Departments
10)SELECT COUNT(Sections) FROM CollegeOfEngineering;
These answers are created to the best effort . Image is not clear. A few of the table naes may be inconsistent.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.