Answer:
true
Explanation:
I think that's what it has been in my time of classes
Answer:
SELECT DISTINCT VendorName FROM Vendors
WHERE VendorName= ANY (SELECT VendorName FROM Vendors JOIN Invoices ON Vendors.VendorID = Invoices.VendorID) ORDER BY VendorName;
Explanation:
All bold faced words are sql keywords for different purposes. The subquery return the all values which matches the join condition and main query will choose only distinct values and make them in order of VendorName.
There many other queries also return the same result as returned by given query.
Answer:
C. reduce his variable expenses.
Explanation:
There are two types of expenses: Variable expenses and Fixed Expenses. Fixed Expenses are the expenses that are fixed for every month and its difficult to reduce these expenses such as house rent, fuel or travel expenses to go for work, utility bills. These are almost fixed for every month and it is difficult to reduce them. On the other hand, variable expense are the expense that vary for every month and can reduce easily. These expenses includes eating outside at restaurants, clothing, enjoying and arranging parties.
Rahul should reduce his variable expense to reduce his spending. This could be the easier way to reduce the expenses and save more. First option is not valid as he want to reduce his spending, this shows that he is satisfied with his current job but worried about extra expenses each month. This is the reason option C is the better choice for him to reduce expense.
