Need help with an SQL query.

I am trying to develop a Student Database System. One of the tables is of Attendance. The table is described as follows.
create table attendance(
id int primary key,
name varchar(20),
subject varchar(20),
current_month varchar(20),
date_of_leave varchar(20));
There are currently only 3 subjects which are in a tag. I want to query the name of the student who have taken more than three days of leave for a subject in the current_month.How do i do it? I am using mysql.

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!