SqlÓï¾äѧϰ±Ê¼Ç(3) ²åÈëÊý¾Ý

ÕâÀïʹÓõÄÊý¾Ý¿âºÍÊý¾Ý±í·Ö±ðÀ´×ÔSqlÓï¾äѧϰ±Ê¼Ç£¨1£©——´´½¨Êý¾Ý¿âºÍSqlÓï¾äѧϰ±Ê¼Ç£¨2£©——´´½¨Êý¾Ý±í
use RetalDB
go
--²åÈëÊý¾Ýµ½±ítb_movie_type
insert tb_movie_type values(0,'ÆÕͨƬ','Regular')
insert tb_movie_type values(1,'ÐÂƬ','NewRelease')
insert tb_movie_type values(2,'¶ùͯƬ','Children')
---²åÈëÊý¾Ýµ½tb_movie
insert tb_movie(movie_id,movie_name,movie_price,movie_type_id,movie_detail)
values (2010,'´óºìµÆÁý¸ß¸ß¹Ò',2,0,'ijijijÅÄÉãµÄ....')
insert tb_movie(movie_id,movie_name,movie_price,movie_type_id,movie_detail)
values (2011,'Èý¹ú',2,1,'ÐÂƬ¶î£¬ºÃºÃ¹ÛÉÍ...')
insert tb_movie(movie_id,movie_name,movie_price,movie_type_id,movie_detail)
values (2012,'2010',2,0,'ÊÀ½çÄ©ÈÕ...')
insert tb_movie(movie_id,movie_name,movie_price,movie_type_id,movie_detail)
values (2013,'ů´º',2,0,'¸ÐÈ˵IJ»µÃÁËÁË....')
--²åÈëÊý¾Ýµ½±ítb_userÖÐ
insert tb_user values(2010001,'Áõ±¸',0)
insert tb_user values(2010002,'Áõ±¸',0)
insert tb_user values(2010003,'¹ØÓð',0)
insert tb_user values(2010004,'ÕÅ·É',0)
insert tb_user values(2010005,'ÕÔÔÆ',0)
insert tb_user values(2010006,'Öî¸ðÁÁ',0)
--²åÈëÊý¾Ýµ½±ítb_retalÖÐ
insert into tb_retal (user_id,movie_id) values (2010001,2010)
insert into tb_retal (user_id,movie_id,rent_time,rent_fee)
values (2010002,2010,Convert(datetime,'5/1/2010'),2)
insert into tb_retal (user_id,movie_id,rent_time,rent_fee)
values (2010002,2010,'5/1/2010',2)
insert into tb_retal (user_id,movie_id,rent_time,rent_fee)
values (2010004,2010,'2010.03.01',2)
insert into tb_retal (user_id,movie_id,rent_time,rent_fee)
values (2010004,2012,'2010.06.01',2)