Mysql random practice 2

 create database synergy;

use synergy;

create table student 

(rollno int primary key,

name varchar(50),

marks int not null,

grade varchar(2),

city varchar(15)

);

insert into student

(rollno, name, marks, grade, city)

values 

(101,"Lipu",85,"B","Kdp"),

(102,"Deba",88,"A","Ctc"),

(103,"Adi",81,"B","Khu"),

(104,"Jyoti",89,"o","Ctc");

select * from student;

select max(marks)

from student;

select city, name, count(rollno) 

from student 

group by city, name;