《数据库系统系统原理》实验课报告.docx

1、Findthename,loannumberandloanamountofallcustomers;renamethecolumnnameloan_numberasloan_id.2、Findthenamesofallcustomerswhosestreetincludesthesubstring“Main”.3、Findallcustomerswhohavealoan,anaccount,orboth:4、Findallcustomerswhohavebothaloanandanaccount.5、Findallcustomerswhoha