Posts

Showing posts from March, 2024

Stopwatch using HTML AND CSS AND JAVASCRIPT

Image
 HTML <! DOCTYPE html > < html lang = "en" > < head >     < meta charset = "UTF-8" >     < meta name = "viewport" content = "width=device-width, initial-scale=1.0" >     < link rel = "stylesheet" href = "style.css" >     < title > Document </ title > </ head > < body >     < div class = "stopwatch" >         < h1 id = "display" > 00:00:00 </ h1 >         < div class = "buttons" >             < img src = "stop.png" onclick = " watchStop ()" >             < img src = "start.png" onclick = " watchStart ()" >             < img src = "reset.png" onclick = " watchReset ()" >         </ div >     </ div >     < script >     ...

Payment database practice MySQL

 create database payment; use payment; create table pay (id int primary key, name varchar(20), mode varchar(15), city varchar(20) ); insert into pay (id,name,mode,city) values (101,"Olivia","Netb","Portland"), (102,"Ethan","Cred","Miami"), (103,"Maya","Cred","Seattle"), (104,"Liam","Netb","Denver"), (105,"Sophia","Cred","New Orleans"), (106,"Celeb","Debt","Minneapolis"), (107,"Ava","Debt","Phoenix"); select * from pay; select mode , count(name) from pay  group by mode;

Practice quesition 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; select city , avg(marks) from student group by city order by avg(marks) desc;

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;

My Sql practice set 1

Image
 create database xyz; use xyz; create table info( id int primary key, name varchar(20), salary int not null ); insert into info (id,name,salary) values (1, "adam", 25000), (2, "Bob", 30000), (3, "Casey", 40000); select * from info; output

Mysql practice random

 create database stud1; create database stud2; create database college; create database newcollege; create database if not exists college; drop database stud2; drop database if exists stud1; use college; create table student ( id int primary key, name varchar(50), age int not null ); insert into student values(1, "Debadatta", 18); insert into student values(2, "Jyoti", 18); insert into student values(3, "Aditya", 50); insert into student values(4, "Arabinda", 75); select * from student; show databases; show tables; use newcollege; create table rollnum( rollno int primary key, name varchar(50) ); select * from rollnum;  insert into rollnum   (rollno, name)  values  (101, "Sunil"),  (102, "Arjun"),  (103, "pritam");    select * from rollnum;