I will write mysql queries using joins, ctes and window functions

Sommige informatie wordt in het Engels weergegeven.

India

Ik spreek Telugu, Engels

Meghani S

AI/ML Engineer skilled in building intelligent, data-driven applications using Python, Machine Learning, Deep Learning, Flask, and Streamlit. Experienced in predictive modeling, analytics dashboards,...
Over deze dienst

Are you looking for help with MySQL queries, database management, or SQL data analysis?

I can help you write, execute, debug, and analyse SQL queries using MySQL to transform your database information into meaningful insights.

My Services Include:

SQL Fundamentals

  • SELECT, WHERE, ORDER BY and DISTINCT
  • INSERT, UPDATE and DELETE
  • Aggregate functions: SUM, AVG, COUNT, MIN and MAX
  • GROUP BY and HAVING
  • CASE WHEN statements

SQL Joins

  • INNER JOIN
  • LEFT JOIN
  • Multiple-table JOINs
  • Combining data from related tables

Advanced SQL

  • Subqueries and nested queries
  • Common Table Expressions (CTEs)
  • Complex SQL queries
  • Data filtering and conditional logic

Window Functions

  • ROW_NUMBER()
  • RANK()
  • DENSE_RANK()
  • LAG()
  • OVER()
  • PARTITION BY
  • ORDER BY within window functions

SQL Data Analysis

  • Customer spending analysis
  • Top customer identification
  • Product-wise revenue analysis
  • Category-wise revenue contribution
  • Monthly revenue analysis
  • Month-over-month revenue comparison
  • Revenue growth percentage
  • Customer order frequency
  • Sales and payment analysis

Tools:

  • MySQL 8.0
  • MySQL Workbench

What You Will Receive:

  • SQL queries based on your requirements
  • Executed query results
  • Clean and readable SQL code
  • Query explanations
  • SQL-based r

Databasetype:

Relationele database

Platform:

MySQL

Expertise:

SQL

•

DDL

•

DML

•

DQL

Mijn portfolio