Answer the question listed below based on the sample databas

Answer the question listed below based on the sample database above.

These are SQL problems. Queries should execute properly on server setup described above. The queries should generate the correct information for any instance of the sample database.p.s do not use Limit

1. List all the client names and corresponding creditLimits for those who have one of the lowest 3 credit limits.

Consider the following schemas: Customers: (CustomNumber, CompanyName, ContactFirstName, ContactLastName, Phone, Addressline1, AddressLine2, City, State, Country, PostalCode, SalesEmployeeNumber, CreditLimit) Employees: (EmployeeNumber, LastName, FirstName, Extension, Email, OfficeCode, ReportTo, JobTitle) Office: (EmployeeNumber, LastName, FirstName, Extension, Email, OfficeCode, ReportTo,obTitie) OrderDetails: (OrderNumber, ProductCode, QuantityOrdered, PriceEach, OrderLineNumber) Orders: (OrderNumber, OrderDate, RequiredDate, ShippedDate, Status, Comments, CustomerNumber) Payments: (CustomerNumber, CheckNumber, PaymentDate, Amount) Producttine: (ProductLine, textDescription, htmlDescription, Image) Products: (ProductCode, ProductName, ProductLine, ProductScale, ProductVendor, Product Discreption, QuantitylnStock, BuyPrice, MSRP)

Solution

Answer