DELIMITER

create database car;
use car;
create table car(make varchar(10),type int,year int,colour varchar(10));
insert into car values("mahindra",1,2009,"black");
insert into car values("thar",3,2004,"red");
insert into car values("maruthi",2,2009,"black");
insert into car values("BMW",9,2009,"marron");
insert into car values("lambor",7,2005,"black");
insert into car values("ferria",6,2006,"blue");
insert into car values("hyundia",5,2003,"white");

select * from car;

DELIMITER//
CREATE PROCEDURE CAR1()
BEGIN
SELECT * FROM car ORDER BY value,make DESC;
END//
DELIMITER;
CALL CAR1;

DELIMITER //
CREATE PROCEDURE CAR2(IN year_filter int)
BEGIN
SELECT * FROM car where year=year_filter order by value,make DESC;
END//
DELIMITER;
CALL car2(2009);