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

Certaines informations sont présentées en anglais.

Inde

Je parle Telugu, Anglais

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,...
À propos de ce service

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

Type de base de données:

Base de données relationnelle

Plateforme:

mySQL

Expertise:

SQL

•

DDL

•

DML

•

DQL

Mon portfolio