Answer: I think it's D.
Explanation: I'm sorry if I chose the wrong answer, I'm not too good with stuff like this.
Answer:
Waste management (or waste disposal) includes the activities and actions required to manage waste from its inception to its final disposal. ... Waste management deals with all types of waste, including industrial, biological and household. In some cases, waste can pose a threat to human health.
Answer:
Computers are used for Business
Computers are used for Education
Computers are used for Science
Computers are used for Communication.
Following are the SQL query commands to the given question:
Query:
select customer_name /*using inner select query */
from
(
/* select column names*/
SELECT customer_name,
transaction_time,
next_transaction_time,
TIME_TO_SEC(TIMEDIFF(next_transaction_time, transaction_time)) as difference
FROM ( SELECT customer_name,
transaction_time,
( SELECT MIN(transaction_time)
FROM customer_transactions T2
WHERE T2.customer_name = T1.customer_name
AND T2.transaction_time > T1.transaction_time
) AS next_transaction_time
FROM customer_transactions T1
) AS T
) X
/*Using group by clause with min and max method*/
GROUP BY customer_name HAVING MIN(difference) = 10 and MAX(difference) = 10
Explanation of query:
- In this question, Subqueries, group by clause, with the max and min method is used which purpose can be defined as follows:
- It is utilized for returning information which is used to better limit the data to be found in the primary query.
- It returns no or more rows through one or more tables or views of the database.
- It organizes rows into groups depending on its values for one or more columns.
- Grouping is usually utilized to use some kind of aggregate function for every group.
- The function MIN() returns the lowest value of the column chosen.
- The function MAX() returns the highest number in the column chosen.
Learn more:
brainly.com/question/1765746