Answer:
See explaination
Explanation:
#Run the code in the python version 3.x.
#Define the function.
def shampoo_instructions(num_cycles):
#Check the cycles to be greater than 1.
if num_cycles < 1:
#Display the statement.
print('Too few.')
#Check the cycles to be greater than 4.
elif num_cycles > 4:
#Display the statement.
print('Too many.')
#The else part.
else:
#Initialize the variable.
N = 1;
#Begin the for loop.
for N in range(N, num_cycles+1):
#Print the result.
print(N , ": Lather and rinse.")
#Print the statement.
print('Done.')
#Call the function.
shampoo_instructions(2)
Explanation:
"Select vendor_name as Vendor_Name,
default_account_number as Default_Account_No ,
account_description as Account_Description
From Vendors v, General_Ledger_Accounts ledger
where (add the join condition here)
Order by account_description, vendor_name"
Note: In the above statement, include the alias name appropriately and then execute the query
The "select statement" should contain the list of columns to be displayed
"From statement" should contain the name of the table from which data needs to be fetched.
"Where clause" defines the relationship as well the condition that needs to be executed
"Order by clause" defines the sorting mechanism with the relevant field
