Given two tables with the following columns: USERS user id date time stamp post id user action action details POST_REMOVED_BY_REVIEWER post id date time stamp report the daily ratio of posts removed by reviewers out of the user reported posts (user action = report)
SQL: 1. given table products(product_id, brand_name,product_name, product_price), find brand_names with avg price > 3 and having more then 5 products 2.given table sales (sale_id, promotion_id, sale_amount, other columns), find % of how sales with promotions ( promotion_id is null) are doing in comparison to all sales. Coding(Java): 1. find avg word length in a sentence 2. ip address validation 3. Friends problem [[A,B], [B,D],[E]...] ( List of lists);
Given a purchase table(user, purchase_time, amount_of_money, level1_category, level2_category), write a sql query to find the customer purchase in continue 7 days and with the total money greater than 500
What does SQL stand for
what do you look for a company
Describe different JOINs in SQL. Having a categorical variable with thousands distinct values, how would you encode it? How to find linear trends in time series. How to find the flow in a matrix showing temperature. ...
If you take 3 subsequent number (n, n+1, n+2) and know, that n and n+2 are prime numbers, can you proove, that n+1 is always dividable by 6?
What is AUC? What lies on x-axis and y-axis of AUC curve?
What would you do if your manager was leaking company confidential information?
Q. If you had to chose only one financial statement, which one would you choose?
Viewing 401 - 410 interview questions