SQL QUERY CHALLENGE – TEST YOUR DBMS KNOWLEDGE

━━━━━━━━━━━━━━━━━━━━━━

Consider the following table:

Students

| ID | Name | Marks |
|---|---|---:|
| 1 | Rahul | 75 |
| 2 | Priya | 90 |
| 3 | Amit | 60 |
| 4 | Neha | 85 |
| 5 | Karan | 95 |

Question:

Which SQL query will display students who scored more than 80 marks?

A.

SELECT * FROM Students
WHERE Marks < 80;

B.

SELECT * FROM Students
WHERE Marks > 80;

C.

SELECT Name FROM Students;

D.

SELECT * FROM Students
ORDER BY Marks;

━━━━━━━━━━━━━━━━━━━━━━

Comment your answer: A, B, C or D.

Correct answer and explanation in the next SQL challenge!

UPDATEGADH | Technology Tutorials and Projects

#SQL #SQLChallenge #DBMS #BCAStudents #MCAStudents #CodingChallenge #UPDATEGADH

Advanced E-Learning Management System (Udemy Clone) Using PHP and MySQL

The Advanced E-Learning Management System is a web-based course marketplace where instructors can create and manage courses, while students can enroll in courses, watch lessons, attempt quizzes, submit assignments and earn certificates.


KEY FEATURES

1. Public Course Marketplace
2. Separate Admin, Instructor and Student Panels
3. Course Creation and Approval
4. Course Sections and Lesson Management
5. Video, PDF, Text and Link-Based Lessons
6. Free and Paid Course Enrollment
7. Timed Quizzes and Results
8. Assignment Submission and Grading
9. Course Completion Certificates with Verification IDs
10. Payment Records and Refund Management
11. Course Reviews and Ratings Management
12. Student Progress Tracking
13. Instructor Earnings Management
14. Reports and CSV Export
15. Messages and Notifications

PROJECT MODULES

- Authentication Module
- Course Management Module
- Curriculum Management Module
- Enrollment Module
- Quiz Management Module
- Assignment Management Module
- Payment Management Module
- Certificate Management Module
- Communication Module
- Reports Module

USER ROLES

- Admin: Manages students, instructors, courses, categories, enrollments, payments and reports.
- Instructor: Creates courses, uploads lessons, manages quizzes and assignments, and tracks student progress.
- Student: Browses courses, enrolls, watches lessons, attempts quizzes and submits assignments.


DOWNLOAD COMPLETE PROJECT
https://updategadh.com/e-learning-management-system/

UPDATEGADH | Technology Tutorials and Projects

#PHPProject #MySQLProject #ELearningManagementSystem #UdemyClone #BCAProjects #MCAProjects #FinalYearProject #UPDATEGADH