푸들푸들

웹 기획 설계서 작성 - PowerPoint페이지 - 기능 설명

goods 중심소비자 / 관리자

(rental x inventory) x film{(rental x inventory) x film } x customerSELECT c.customer_id customerId ,t2.film_id ,t2.title ,t2.release_year ,t2.length ,t2.rating ,t2.rental_id ,t2.rental_date ,t2.return_date ,t2.rental_duration ,t2.rental_rate ,t2.replacement_costFROM (SELECT t1.rental_id ,t1.rental_date ,t1.return_date ,t1.customer_id ,t1.film_id ,f.title ,f.release_y..

고객 이름 검색이름에 'one'이 들어간 활성화 되어있는 고객SELECT customer_id , first_name , last_name , emailFROM customerWHERE active = 1 AND LOWER(CONCAT(first_name,last_name)) LIKE CONCAT('%',LOWER('one'),'%');

대여 중인 비디오 -> rental.return_date is null반납 날짜가 null인 것SELECT inventory_id, customer_idFROM rentalWHERE return_date IS NULL;SELECT i.*, t.*FROM inventory i LEFT OUTER JOIN (SELECT inventory_id, customer_id, rental_date FROM rental WHERE return_date IS NULL) t ON i.inventory_id = t.inventory_id; + film.titleSELECT t1.*, t2.*FROM (SELECT i.inventory_id , i.film_id , f.title , i.last_update , ..