Given the following relations, write an SQLite query with JOIN keyword to retrieve the full name of employees with custo

[answerhappygod]

Given The Following Relations Write An Sqlite Query With Join Keyword To Retrieve The Full Name Of Employees With Custo 1 (25.39 KiB) Viewed 31 times

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. FullName 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