CREATE TABLE students (
student_id int PRIMARY KEY,
student_name varchar(100),
grade int,
class_id int,
exam_date date
);
INSERT ALL
INTO students (student_id, student_name, grade, class_id, exam_date)
VALUES (1, 'sdsd', 92, 3, TO_DATE('2024-10-05', 'YYYY-MM-DD'))
INTO students (student_id, student_name, grade, class_id, exam_date)
VALUES (2, 'Bob', 85, 4, TO_DATE('2024-10-06', 'YYYY-MM-DD'))
INTO students (student_id, student_name, grade, class_id, exam_date)
VALUES (3, 'Chsdrlsde', 78, 5, TO_DATE('2024-10-07', 'YYYY-MM-DD'))
INTO students (student_id, student_name, grade, class_id, exam_date)
VALUES (4, 'sadh', 68, 8, TO_DATE('2024-10-08', 'YYYY-MM-DD'))
INTO students (student_id, student_name, grade, class_id, exam_date)
VALUES (5, 'Eve', 55, 1, TO_DATE('2024-10-09', 'YYYY-MM-DD'))
SELECT * FROM dual;
select TO_CHAR(exam_date, 'Day') AS weekday
FROM students;
select s.*,
Case
When grade > 90 THEN 'A'
When grade > 80 Then 'B'
When grade > 70 Then 'c'
When grade > 60 Then 'D'
Else 'E'
end as new_grade
from students s
select * from [Link];
SELECT
CASE
WHEN MIN(salary) > 1000 THEN
'Average Salary: ' || TO_CHAR(AVG(salary), '9999.99')
ELSE
'High Salary: ' || TO_CHAR(MAX(salary)) ||
', Low Salary: ' || TO_CHAR(MIN(salary))
END AS salary_info
FROM [Link]
