러닝 SQL: 데이터 생성, 검색, 조작까지 데이터 제대로 주무르기

410

러닝 SQL

. . . . . . . . . . . . . )> cust_data.last_name,

. . . . . . . . . . . . . )> f.Rating,

. . . . . . . . . . . . . )> flatten(cust_data.rental_data.Payments)

. . . . . . . . . . . . . )> payment_data

. . . . . . . . . . . . . )> FROM films f

. . . . . . . . . . . . . )> INNER JOIN

. . . . . . . . . . . . . )> (SELECT c.`First Name` first_name,

. . . . . . . . . . . . . )> c.`Last Name` last_name,

. . . . . . . . . . . . . )> flatten(c.Rentals) rental_data

. . . . . . . . . . . . . )> FROM customers c

. . . . . . . . . . . . . )> ) cust_data

. . . . . . . . . . . . . )> ON f._id = cust_data.rental_data.filmID

. . . . . . . . . . . . . )> WHERE f.Rating ...