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

👀 Don't miss this 🚀

Posture Detection Using Machine Learning

Posture Detection Using Machine Learning in Python is a computer vision project using Python, Flask, MediaPipe, OpenCV, and machine learning to classify.

👇 Tap the button below to read more

#ProjectWithSourceCodes #StudentsOfIndia

🧠 Learn this before your interview 📚

Fresher resume: 6 rules recruiters actually check

📄 1 page only, simple layout (ATS friendly)
🎯 Skills section matching the job post
🚀 2-3 projects with GitHub links + what YOU built
📊 Numbers: "improved speed by 40%", "500+ users"
❌ No photos, no fancy graphics, no spelling mistakes

🔖 Save it & share with your batchmates!

#Placement #InterviewPrep #ProjectWithSourceCodes #StudentsOfIndia