Databases
SQL Query to Return Names of Marketing Employees with 5+ Years of Experience
AskAI
Write a query to return the names of employees who work in the Marketing department and have at least 5 years of experience.
Summing Even Numbers in an Array
AskAI
This technical problem deals with creating a function that will take in an array of integers and return the sum of all the even numbers in the array.
Find all pairs of rows in a table of data where the values in the columns are...
AskAI
Given a table of data with two columns, this technical problem seeks to find all pairs of rows where the values in the columns are equal. The input is a list of data values, and the output is also a list of data values.
Update "last_updated" column on table with insert or update trigger
AskAI
A trigger is needed that will update the "last_updated" column on a table every time a row is inserted or updated.
Get the Top 5 Most Popular Articles from a Database
AskAI
Write a SQL query that returns the top 5 most popular articles from a database of articles.
"Find the total number of products ordered for each product"
AskAI
This technical problem deals with finding the total number of products ordered for each product, using two tables (products and orders). An example input and output is given.
SQL query to find customers who have purchased products with a list price...
AskAI
This technical problem deals with finding customers who have purchased products with a list price greater than $100.
SQL: Join Two Tables
AskAI
Write a SQL query to find all the rows from table A that have a matching row in table B.
