SQL training

Import this exports from the Micka:

1. CREATE TABLE `userst` (
`id` int(11) NOT NULL auto_increment,
`login` varchar(64) collate cp1250_czech_cs NOT NULL default '',
`pwd` varchar(64) collate cp1250_czech_cs NOT NULL default '',
`email` varchar(133) collate cp1250_czech_cs NOT NULL default '',
`u_name` varchar(64) collate cp1250_czech_cs default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=cp1250 COLLATE=cp1250_czech_cs;

insert into userst values('1', 'vlk', 'volf', 'vlk@email.cz', 'jiri vlk');
insert into userst values('2', 'novak', 'newmann', 'alois.novak@login.cz', 'alois novak');
insert into userst values('3', 'smith', 'john', 'john.smith@gggmail.com', 'john smith');
insert into userst values('4', 'babka', 'hokus1', 'babka@fs.cvut.cz', 'babka');
insert into userst values('5', 'berta', 'berta', 'alik@fs.cvut.cz', 'alik');
insert into userst values('6', 'bock', 'john', 'jbock@vse.cz', 'john bock');
insert into userst values('7', 'sob', 'los', 'a@cas.cz', 'sob');
insert into userst values('9', 'kos', 'zob', 'kos@cas.cz', 'kosi');
insert into userst values('11', 'pes', 'dog', 'pes@cs.cas.cz', 'pes');
insert into userst values('12', 'mlz', 'slimak', 'mlz@cas.cz', 'mlz');
2. CREATE TABLE `carst` (
`id` int(11) NOT NULL auto_increment,
`regno` varchar(10) default NULL,
`type` varchar(64) NOT NULL default '',
`priceperday` float(10,2) unsigned NOT NULL default '0.00',
`priceperkm` float(5,2) default '0.00',
`isfree` int(11) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1250;

insert into carst values('1', 'PLC-15', 'Audi A100', '25.00', '2.00', '0');
insert into carst values('2', 'RAD 1D', 'Citroen 2CV', '5.00', '1.00', '0');
insert into carst values('3', 'TMS AL', 'Renault 5', '9.00', '2.00', '1');
insert into carst values('4', 'ABS RL', 'Renault 8', '11.00', '1.00', '0');
insert into carst values('5', 'LI2FO', 'Renault 12', '10.00', '1.00', '1');
insert into carst values('6', 'FI4FO', 'Peugeot 304', '8.00', '1.00', '0');
insert into carst values('7', 'ARD LISA', 'Ford Escort', '12.00', '3.00', '1');
insert into carst values('8', 'ABB CH', 'Fiat 125', '10.00', '2.00', '0');
insert into carst values('9', 'DAG GER', 'Peel P50', '13.00', '3.00', '1');
insert into carst values('10', 'AS-73-11', 'Praga V3S', '13.00', '7.00', '1');
insert into carst values('11', 'AA-1', 'Trabant 601', '15.00', '1.00', '1');
insert into carst values('12', 'B-BB', 'Fiat', '10.00', '2.00', '1');
insert into carst values('13', 'KKCV', 'Wartburg', '30.00', '1.00', '1');
3. CREATE TABLE `orderst` (
`id` int(11) NOT NULL auto_increment,
`id_c` int(11) default NULL,
`id_u` int(11) default NULL,
`o_from` date default NULL,
`o_to` date default NULL,
`km1` int(11) default NULL,
`km2` int(11) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=cp1250 COLLATE=cp1250_bin;

insert into orderst values('1', '2', '4', '2013-05-31', '2013-06-15', '147215', '147320');
insert into orderst values('2', '5', '1', '2013-06-17', null, '131927', null);
insert into orderst values('3', '1', '4', '2013-06-21', '2013-06-23', '256317', '256921');
insert into orderst values('4', '3', '3', '2013-06-27', null, '237143', null);
insert into orderst values('5', '6', '4', '2013-06-27', null, '96511', null);
insert into orderst values('6', '4', '5', '2013-06-27', null, '2', null);
insert into orderst values('7', '2', '4', '2013-05-31', '2013-06-15', '147215', '147320');
insert into orderst values('8', '5', '1', '2013-06-17', null, '131927', null);
insert into orderst values('9', '1', '4', '2013-06-21', '2013-06-23', '256317', '256921');
insert into orderst values('10', '3', '3', '2013-06-27', null, '237143', null);
insert into orderst values('11', '6', '4', '2013-06-27', null, '96511', null);
insert into orderst values('12', '1', '3', '2014-01-23', '2014-01-25', '123456', '123567');
insert into orderst values('13', '1', '4', '2014-01-26', null, '123569', null);
insert into orderst values('14', '2', '4', '2014-01-27', null, '147321', null);

Tasks:

Samples: