4.which pre-defined feature is known as functions in Excel? a.formula b.property c. data
1 answer:
You might be interested in
Answer:
Step by step code along with explanation and output is given below
Explanation:
We can solve this problem using if elif else approach
def main():
# prompts the user to enter an integer from 1 to 10
num = int (input('Enter a number in the range of 1 to 10:\n'))
# using the if elif print out the roman numeral from 1 to 10
if num == 1:
print ('Roman Numeral for 1 is I')
elif num == 2:
print ('Roman Numeral for 2 is II')
elif num == 3:
print ('Roman Numeral for 3 is III')
elif num == 4:
print ('Roman Numeral for 4 is IV')
elif num == 5:
print ('Roman Numeral for 5 is V')
elif num == 6:
print ('Roman Numeral for 6 is VI')
elif num == 7:
print ('Roman Numeral for 7 is VII')
elif num == 8:
print ('Roman Numeral for 8 is VIII')
elif num == 9:
print ('Roman Numeral for 9 is IX')
elif num == 10:
print ('Roman Numeral for 10 is X')
# using the else print out error message whenever user enters any other number not listed above
else:
print ('Error! Wrong Input')
# call the main function
main()
Output:
Enter a number in the range of 1 to 10:
6
Roman Numeral for 6 is VI
Enter a number in the range of 1 to 10:
15
Error! Wrong Input
Answer:
SELECT customer_last_name, customer_city, customer_zip FROM customers WHERE customer_state = 'IL' ORDER BY customer_last_name DESC;
Explanation:
Here, we are given a SCHEMA with the table name customers.
It's creation command and commands to insert values are also given.
We have to print the customer last name, city and zip code of all the customers who have their state as IL in the decreasing order of their last names.
Let us learn a few concepts first.
1. To print only a specified number of columns:
We can write the column names to be printed after the SELECT command.
2. To print results as per a condition:
We can use WHERE clause for this purpose.
3. To print in descending order:
We can use ORDER BY clause with the option DESC to fulfill the purpose.
Therefore, the answer to our problem is:
SELECT customer_last_name, customer_city, customer_zip FROM customers WHERE customer_state = 'IL' ORDER BY customer_last_name DESC;
Output of the command is also attached as screenshot in the answer area.
