Subject: Computers and technology - Page 2

Solved
Solved
MYSQL I need a query code I am confused with two questions Display each classification that has a total of more than 70 parts on hand. List the classification and the total on hand as ‘More than 70’ What is the average quoted price, maximum quoted price, and minimum quoted price of all orders? Display the average as ‘Average Quoted Price’, maximum quoted price as ‘Maximum Quoted Price’, and minimum quoted price as ‘Minimum Quoted Price’. Extra decimal places are okay for now. Insert your snip of the query and resultset together here:

MYSQL I need a query code I am confused with two questions Display each classification that has a total of more than 70 parts on hand. List the classification and the total on hand as ‘More than 70’ What is the average quoted price, maximum quoted price, and minimum quoted price of all orders? Display the average as ‘Average Quoted Price’, maximum quoted price as ‘Maximum Quoted Price’, and minimum quoted price as ‘Minimum Quoted Price’. Extra decimal places are okay for now. Insert your snip of the query and resultset together here:

Solved
Solved
Solved
Ask the user to think of a number between zero and one hundred. Your goal is to guess the number in as few guesses as possible. The user will inform you if you guessed too high, low or correct. Start by always guessing the middle number 50. If the user informs you it’s too low, then try 75. If 50 was too high, then try 25. Always guess the middle of the range of numbers left. In doing so, the range of numbers will be cut in half after each guess. If done correctly, no more than 7 guesses are needed. Print out “you cheated” if you reach 7 guesses and are still wrong.

Ask the user to think of a number between zero and one hundred. Your goal is to guess the number in as few guesses as possible. The user will inform you if you guessed too high, low or correct. Start by always guessing the middle number 50. If the user informs you it’s too low, then try 75. If 50 was too high, then try 25. Always guess the middle of the range of numbers left. In doing so, the range of numbers will be cut in half after each guess. If done correctly, no more than 7 guesses are needed. Print out “you cheated” if you reach 7 guesses and are still wrong.

Solved
Solved
Solved
What effect do coworkers have on the socialization of new employees? O a Coworkers potentially do all of these things. Ob Coworkers provide valuable support and information to newcomers. Oc Od Coworkers have no benefit to the socialization process and should be separated from newcomers as much as possible. By welcoming the newcomer to the team, coworkers tend to offer more job-related information to the newcomer. Through social interaction, coworkers reduce the newcomer

What effect do coworkers have on the socialization of new employees? O a Coworkers potentially do all of these things. Ob Coworkers provide valuable support and information to newcomers. Oc Od Coworkers have no benefit to the socialization process and should be separated from newcomers as much as possible. By welcoming the newcomer to the team, coworkers tend to offer more job-related information to the newcomer. Through social interaction, coworkers reduce the newcomer's stress during socialization. Oe

Solved
Solved
Write an algorithm capable of accepting a maximum of 35 records from the user. The algorithm should allow the user to enter the names of vendors who bought magazines, the magazine title, the quantity purchased as well as the name of the publisher, and the publisher recommended price, from which the income will be calculated. The algorithm is capable of generating various reports. The main output required is a summary of incomes with the following information: Total Income from Magazines sold: $55,600 Total Amount due to Publishers: $33,360 Total Amount earned by Company: $22,240 The user will indicate the number of records to be entered. The publishers receive 60% of the Sales value. A discount will be given to vendors based on the rates in the table below: quantity - <=200, rate 10% quantity >200 but <=500, rate 15% quantity >500, rate 20% Management has also requested that the algorithm determine and display the most amount of money made from any transaction, as well as the title of the magazine, the name of the vendor, and name of the publisher.

Write an algorithm capable of accepting a maximum of 35 records from the user. The algorithm should allow the user to enter the names of vendors who bought magazines, the magazine title, the quantity purchased as well as the name of the publisher, and the publisher recommended price, from which the income will be calculated. The algorithm is capable of generating various reports. The main output required is a summary of incomes with the following information: Total Income from Magazines sold: $55,600 Total Amount due to Publishers: $33,360 Total Amount earned by Company: $22,240 The user will indicate the number of records to be entered. The publishers receive 60% of the Sales value. A discount will be given to vendors based on the rates in the table below: quantity - <=200, rate 10% quantity >200 but <=500, rate 15% quantity >500, rate 20% Management has also requested that the algorithm determine and display the most amount of money made from any transaction, as well as the title of the magazine, the name of the vendor, and name of the publisher.