Parch And Posey a paper printing company

o Calculating Total Revenue per year

o Total Revenue for each paper type where I skillfully utilized the

UNION ALL method to consolidate distinct sales data for unified

reporting

o Mapping region and account names for each order to understand

geographic and client distribution

o Analyzing sales performance per region to identify key areas

o Identifying the top-performing sales personnel in each region using

CTEs (Common Table Expressions) for structured and efficient

querying

o Determining the monthly sales growth rate to track performance

trends

o Implementing a procedure for sales persons' running totals,

showcasing advanced SQL capabilities