Page 1 of 1
Q2.3 2 Points Given the following relations, write an SQLite query with JOIN keyword to retrieve the full name of employ
Posted: Fri May 20, 2022 10:14 am
by answerhappygod
- Q2 3 2 Points Given The Following Relations Write An Sqlite Query With Join Keyword To Retrieve The Full Name Of Employ 1 (105.24 KiB) Viewed 21 times
Q2.3 2 Points Given the following relations, write an SQLite query with JOIN keyword to retrieve the full name of employees with customers and the total number of customers they have, as shown in Figure 1. Full Name is based on the concatenation of fName and IName, separated by a blank space. TotalCustomer is the total number of customers for a particular employee. Employee(employeeld, fName, IName) Customer(customerNo, fName, IName, email, employeeld) FullName TotalCustomer -- Figure 1: Sample output Enter your answer here