Results for “sql”

Prepare me for a data analyst interview at [company type]. Give me 5 SQL questions with sample tables, 5 statistics concept questions, 2 business case questions, and model answers. Quiz me one at a time if I say 'start'.

Write a script in [language] that generates [number] realistic fake records for [entity, e.g. customers with orders] matching this schema: [schema]. Use a faker library, keep relationships consistent, and output as [SQL/JSON/CSV].

Act as a data analyst. Database: [PostgreSQL / BigQuery / Snowflake / MySQL] Tables: [users(id, created_at), events(user_id, event_name, created_at), orders(...)] Questions: [monthly cohort retention, weekly active users, sign-up to purchase funnel] Write the queries with CTEs and comments, explain each step, and desc…

Act as a backend developer. Framework/tool: [Laravel, Django, Rails, Prisma, Alembic, raw SQL] Database: [PostgreSQL/MySQL] Change needed: [e.g. add column, rename table, split a field] Table size: [rows] Write the up and down migration, any data backfill, how to deploy it safely without downtime (e.g. expand-and-cont…

Act as a senior backend developer. Framework: [e.g. Express, FastAPI, Laravel, Django REST, Spring Boot] Database/ORM: [e.g. PostgreSQL + Prisma] Endpoint: [METHOD /path] What it does: [description] Request body/params: [fields and rules] Auth: [public / logged-in user / admin] Write: 1. The route/controller code 2. I…

Act as a SQL expert. Database: [MySQL / PostgreSQL / SQLite / SQL Server] Tables: [table_name](column1 type, column2 type, ...) [table_name](...) What I want: [describe the result in plain English, e.g. "top 10 customers by total spend in 2025, with their order count"] Please: 1. Write the query with clear aliases and…