Tricky sql queries for interview jobs
Role – Contract (2-3M) Required • 8-10 years of proven experience in Power Apps and Power Automate • Experience in developing Canvas and Model-driven Power App applications • Experience in developing the applications connecting to SharePoint, SQL, Oracle and external APIs • Experience in building automation workflows using Power Automate Development 1. Hands-on Expertise in Power Platform • Expertise in design and develop custom business apps (Canvas Apps, SharePoint Form Apps, Model Driven Apps, Portals) • Expertise in implementing Power Automate Flows (Automated, Instant, Business Process Flow and UI Flows) • Expertise in DataVerse and Azure Databricks and MuleSoft 2. Experience implementing Collaboration Portals...
I'm a BCA student with proficient skills in Microsoft Office, Access, Oracle & my SQL. I'm currently seeking a freelancer with advanced data entry proficiency to assist with data entry tasks. Specifically, I need help with: - Entering data into a document - Ensuring that the document has advanced formatting requirements, including tables, charts, and images Ideal skills and experience for this job include: - Proficiency in MS Office Suite (Word, Excel, PowerPoint, Access) - Experience with advanced document formatting - Attention to detail - Ability to work with data accurately and efficiently Please note that while my project is mainly focused on data entry, a background in database management and SQL will be considered a plus.
I urgently require a proficient SQL Server expert, particularly conversant with SQL Server 2012. My primary challenge is recovering deleted records. Ideal Skills: - Comprehensive understanding of SQL Server 2012 - Expertise in data recovery processes Experience Required: - Proven track record in database recovery - Past work with SQL Server 2012 Your immediate availability for this project is essential. Please, only serious and experienced candidates should bid.
I'm looking for an expert to set up and manage my Amazon, eBay, and Spotify stores. Key Responsibilities: - **Setup and Automation**: Your primary task will be to set up my Amazon, eBay, and Spotify stores. You should be able to automate the listing process to save time and optimize efficiency. - **Inventory Management**: I plan to run a centralized inventory management system. Your role will include keeping track of inventory, ensuring that each platform has accurate stock levels, and that the product information is up-to-date. - **Sales and Traffic Generation**: Your focus will be on eBay. You should have a proven track record of driving traffic and generating sales on eBay. Experience in leveraging the platform's promoted listings and other advertising tools is a plu...
... Key Responsibilities: - Help me in finding job opportunities that match my profile and goals. - Targeted and filtered search - Send LinkedIn messages to recruiters and hiring managers to express my interest and inquire about potential job opportunities. - Utilize my email to contact potential employers if required. - Compensation and Bonuses available if job is secured** discussed during interview - Track job applications and other information via google spreadsheet template I created Ideal Candidate: - Proficient in resume writing, LinkedIn profile enhancement, and cover letter customization. - Familiarity with job search strategies and recruitment processes. - Excellent communication skills, particularly in writing compelling and professional messages. - Previous experienc...
I am in need of a skilled developer to assist with an existing API integration between SilverStripe website and REX Software, with a focus on correcting a data issue that is causing the server to fail with backing up the website due to disk usage. The server technician said: "The disk usage is at 80% so a dump would fail as it would need more space to create a sql file to be transferred. It looks to be an issue with REX and the website framework SilverStripe. It may be that REX is not configured to remove (dump) old data." Your role will involve correct the error so the server does not continue to reach its disk usage and implementing a seamless API integration that successfully synchronizes and updates property listings between these two platforms. Ideal Skills: &bull...
I'm in need of a talented individual from Ghana who can assist me with interview transcription and Akan language translation for market research purposes. Required Skills/Experience: - Proficiency in Akan language and English - Experience with market research data collection and transcription - Excellent attention to detail - Ability to maintain confidentiality The candidate should be able to translate interview transcripts from English to Akan, while ensuring the accuracy and quality of the data collected. The collected data will be used for qualitative analysis, so the individual should have a good understanding of the market research process. This project will be ongoing, with the possibility of more work in the future. Experience in market research...
My goal is to craft a captivating online platform that will serve as a gallery to exhibit a mul...gallery to exhibit a multitude of art pieces. This webpage will principally serve the following functions: * Display more than 20 works of art * Present an artist's biography * Feature various interview videos Ideal Project Executor: - A freelancer with a keen eye for aesthetics, who can create an attractive and immersive user experience. - Experience in website development that focuses on art or related fields. - Proficiency in efficiently organizing large volumes of content in a neat, user-friendly manner. - Expertise in embedding video content into websites. - A deep understanding of my goals for this project. Looking forward to potential collaborations to ...
I'm running a Node.js website where the last user's data...issue promptly. Key Responsibilities: - Investigate the current data display functionality and how it's handling user data. - Correct the code responsible for showing the last user's data to the first user. - Ensure that the correct user data is displayed to each respective user post-login. Ideal Freelancer: - Proficient in Node.js with a deep understanding of data management and display. - Experienced in SQL databases, specifically in managing user data. - Previous experience in debugging and resolving similar issues is a plus. - Deadline-oriented and able to work efficiently to resolve this issue. Please refer to the attached video for better understanding of the issue. Your prompt atte...
I need a skilled individual to help me create a professional slide deck - the presentation is attached below and is titled Freelancer's Global Interview Standards The presentation is to be around 8 to 15 slides in length. I have highlighted in blue in the below presentation document, the titles I want you to focus on creating for the slide deck. Please feel free to use images wherever necessary. Key requirements: - Creating a visually-engaging, professional slide deck - Incorporating provided branding guidelines - Ensuring the slides are clear and concise - Good project management and communication skills, as I aim to be involved in the process to ensure it aligns with my vision
Job Title: Full-Stack Developer for WordPress, .NET Middleware, Azure Integration, and SDK Development Job Overview: We are seeking an experienced Full-Stack Developer to spearhead the development and integration of key system components within our e-commerce platform. The successful candidate will lead initiatives to enhance user interactions by developing a WordPress plugin, building a robust .NET middleware API, and integrating advanced Azure-based messaging services. Additionally, the role involves creating an SDK to facilitate easy integration for third-party AI bot services. This position is crucial for ensuring that our platform not only meets current technological standards but also adapts to future advancements and user needs, enhancing both the scalability a...
I need a small application prototype with the following features: Multi-Employer Job Portal/Admin app (Role Based access) User/applicant App (for Multiple applications to different employers) User Profile Document Upload (Save documents to Db and attachments to Blob Storage ) Send Emails to Employers and applicants back and forth 2 Apps in total ie. admin app and applicant app. job application requirements will be provided. Nodejs, angular, My SQL, ORM, Data Seeding, Migrations should be used.
Seeking a long-term Python Data Scientist and Generative AI expert Your task is to develop a prototype chatbot that is powered by Generative AI and Large Language Model (LLM) to respond to user queries using domain-specific knowledge and RAG implementation. The project will focus on integrating LLM frameworks, managing data preprocessing, and implementing the chatbot's user interactions. ONLY people who respond to below screening questions will be considered: 1) Did you fine-tune an LLM model using LoRA or QLoRA? If so, which model did you fine-tune, and what was the use case? 2) Do you have a GitHub profile? If so, can you share the link? 3) Are you proficient in English, and what is your hourly rate?
Needed: Remote Part-Time WordPress Designer / Publisher ? Please read the entire project and respond only if you are the right candidate and agree with the salary. Automated bids will be ignored. About the Role: Are you a passionate WordPress enthusiast who loves design and development? We are looking for a Remote Part-Time WordPress Developer / Publisher to join our dynamic team. This role offers the flexibility to work from anywhere in Pakistan, collaborating with team members to create and maintain stunning WordPress websites. Responsibilities: Design & Development: Crafting visually appealing and fully functional WordPress websites. Content Management: Publishing and updating content across WordPress sites efficiently. Blog Management: Editing, publishing, and maint...
I'm currently facing a small-scale project that requires the transfer of 200 ebooks from a Sony e-reader to a Kobo e-reader. Handling this many files can be a challenge for an untrained person, and I need an expert on my team. The project requires: - Knowledge and understanding of Kobo E-readers and Sony E-readers - Familiarity with E-book file formats - Able to deliver a precisely organized outcome Handling this quantity of files is no minor task, so I will place high value on the following skills: - Excellent organizational skills to ensure the easy location of each ebook post-transfer. - An understanding of ebook cataloging - managing metadata may become essential - Problem-solving skills, should any issues arise during the transfer process If you can en...
...significantly. I'm looking for someone who can work closely with me, explaining the processes, and potentially carrying out the changes themselves. As this will be an ongoing project, we'll be adding many categories. To ensure you're the right fit for this role, please provide a list of stores you've worked on in the past. Key tasks include: - Extensive customization: We need to go beyond the standard Shopify theme and make significant changes to the store design and layout. - Adding products and categories: You'll be responsible for adding and organizing a large number of products and categories. - Setting up payment and shipping: Ensure a seamless, user-friendly experience for our customers. Communication: - I prefer communicatio...
I urgently need a competent videographer with personal camera and sound equipment to produce engaging, high-quality videos over a two-day period amounting to about 10 hours. These videos will include event coverage and conducting interviews. Key Requirements: * Ability to film in indoor locations. * Adeptness in filming both event videos and interviews. * Expertise to create videos aimed at both marketing and promoting our brand and providing educational information. Skills and Experience: * Solid videography experience. * Proficient use of personal camera and sound equipment. * Proven track record of working on marketing and promotional casings, as well as informative and educational projects.
I have a SQL Server that needs to be accessible over the internet. However, I'm facing connectivity issues, possibly due to closed or blocked ports on my ComCast router model CBR2-T. I need a freelancer to open the necessary ports on the router. The task involves: - Checking the current port status on the router - Identifying the SQL Server port - Opening the port on the router Please bid if you're experienced with network configuration and have dealt with ComCast routers before. Necessary Skills: - Network Configuration - Router Administration - ComCast Router Experience - SQL Server Configuration
I require someone experienced in Linux server management to help optimize the performance of my server. Linux Server Performance Optimization Plesk Obsidian, SQL, PHP Key Responsibilities: - Review the current server setup and performance - Identify areas for improvement - Implement solutions to optimize server performance - Fix the 2 errors. This is not a one-time setup; I may require ongoing management based on the initial optimization results. Your expertise in Linux server management is crucial to this project.
...creative ad designer who specialises in Facebook advertising. The aim is to produce an advert which can be translated into multiple languages to target different countries. The ad is for a downloadable video course, for those whose native language is not English, teaching what to say in a job interview in English. Predominantly my market would be working professionals aged between 25 and 50 who are likely to have to attend job interviews in English. Main tasks would be : - Creating an engaging Facebook ad - zeroing in on target group of potential customers (possible later task) - designing an effective landing page for ad clicks current page (in Italian) can be found at I can provide a translation
I'm in need of a professional web developer to create a platform that serves as an agent management website. The website should have an elegant interface, acco...log in securely. - Profile Management: Agents should be able to edit and manage their profiles. - Commission Tracking: The system should track and calculate commissions for each agent. The specific functionality of the agent registration and login feature is not fully defined yet. The ideal candidate for this project should have experience in building similar systems, understand user account management, and have the ability to design an aesthetically pleasing interface. Requirements can be asked if you are interested, you can build with any framework, preferably javascript based frameworks. Minimal SQL ...
I'm looking for an experienced videographer to capture various aspects of a visit to a company HQ in London. This project will include: - Filming interior shots of the HQ - Filming interviews with employees (YouTube presenter will conduct the interviews) - Capturing B-roll footage of the surrounding area The visit date is Tuesday 18th May. The purpose of the video is to generate a YouTube video that will captivate and engage YouTube viewers. The ideal freelancer should have prior experience in corporate videography, and creating dynamic YouTube content. Please provide samples of previous work of a similar nature when applying.
Please Sign Up or Login to see details.
...seeking a highly skilled Front-End Developer with a strong focus in React(using Typescript) and a minimum of 12+ months of experience in creating web applications. You will be responsible for the development, design, and implementation of our new website's front-end aspects. This is a **6-month contract** position with a competitive hourly rate. **Key Responsibilities** - Developing new user-facing features using React.js and Typescript - Building reusable components and front-end libraries for future use - Familiarity with RESTful APIs and integrating front-end with back-end services. - Optimizing components for maximum performance across a vast array of web-capable devices and browsers - Implementing an intuitive user interface - Designing engaging website...
...looking to set up ActiveMQ JMS messaging for our system, focusing on synchronous and asynchronous messaging. We anticipate a low scale of message traffic, not exceeding 1,000 messages per day. Key responsibilities will include: - Setting up ActiveMQ for JMS messaging - Configuring it to handle synchronous and asynchronous messaging effectively Furthermore, I plan to utilize SOAPUI Open Source for automated testing of these messages. Your role will be essential in ensuring that the system works seamlessly with this tool. I will be expecting below: Create a framework to publish and subscribe messages to ActiveMQ queues Create queries to make sure data is published into the respective tables and assertions to validate Ideal skills and experiences for...
Looking for help in modifying an existing python script and related sql database table The current script - (1) scrapes company financial data from website and populates database (2) scrapes news related to keywords from google news (3)sentiment classification of news items (4)pushes data to sql database The company names and keywords are currently hardcoded in the script Requirement- (1) Company names/urls/keywords (will be provided) to be put in master table in the database (2) The script to loop through and scrape the relevant data and put in database
I'm looking for a freelancer who's great at web scraping to help with a project involving a specific website initially, with potential for more. I'll give you the specific data fields to extract. It'd be great if you: Are really good at web scraping and or Python. Know your way around MS SQL Server databases, not essential but definately an advantage. Understand how to extract data effectively. Understand the need for security and captcha integration if needed. Can work quickly since this project is a priority and needs to be done ASAP. Ultimately, I want to be able to manage the code with your ongoing help, so this could lead to a long-term partnership. I'll share the full details when needed. You will provide source code, documentatio...
As a newly established cyber company, I am looking for a skilled web developer to create an lead generating and informational platform for our business. This website will serve as our primary tool for selling our services and solutions online. Key Features: - The most crucial feature of this website will be the Contact Form. It is vital that potential clients can easily reach out to us with queries or service requests. Products/Services: - The primary focus of the website will be to sell our services and solutions. Therefore, the website needs to be designed in a way that effectively showcases our services and solutions and makes it easy for customers to engage with them. Ideal Skills & Experience: - Proficiency in lead generating website develo...
Required a dot net developer. Speacialized in Microservices acrhitecture based solution. Dotnet Core, C#, SQL, Data transformation, API gateway, Auth based security.
...assist me with my project. I'm looking for a PHP expert who can aid in the development of a web application, website, or mobile app. You should be proficient in both front-end and back-end development, capable of crafting user-friendly interfaces and integrating complex functionalities. Your role will involve: - Understanding project requirements and delivering high-quality work - Developing secure, efficient, and scalable code - Implementing user authentication, integrating databases, and possibly setting up payment processing systems - Ensuring timely and reliable completion of the project If you are a skilled PHP developer with experience in full stack development and are passionate about producing high-quality applications, this project is for you. Your abili...
I'm looking for an experienced Python coder to tackle two key aspects of my project - data analysis and automation. Here's a breakdown of the requirements: - **Data Analysis**: The primary task involves analyzing datasets in CSV format. The selected candidate should be adept with NumPy, able to make sense of the data and derive meaningful insights. - **Automation**: The second crucial aspect is automation. I'm looking to automate certain processes in my project that involve database queries. Proficiency in Django will be necessary here. Ideal candidates for this project would have: - **Strong Python Skills**: You should be well-versed with working on data analysis and automation tasks using Python. - **Experience with NumPy & Django**: Proficienc...
I'm seeking 2-5 experienced tele callers who can effectively communicate about commercial real estate properties. The ideal candidates should possess: - Strong communication skills in English - Proven experience in the real estate sector, particularly with commercial properties - Exceptional phone etiquette and persuasion skills - An ability to handle client queries professionally Your primary task will be reaching out to potential clients to discuss our available commercial real estate listings. Please submit your proposal highlighting your related experience and successful projects.
...issues with the search bar on my site. It suffers from slow loading speed and provides irrelevant results, causing a less than ideal user experience. The existing search feature has been built using PHP. To improve the functionality and user satisfaction, I'm seeking a professional with vast experience in PHP who can implement critical improvements. - Autocomplete Function: For faster and user-friendly search queries, incorporate a reliable autocomplete function. Having this feature can save users' time and enhance the browsing experience. - Enhanced Filtering Options: Alongside the autocomplete feature, the search bar needs to have advanced filtering options to serve the most relevant results to the users. This will not only speed up the site navigation ...
I need a skilled individual to help me create a professional slide deck - the presentation is attached below and is titled Freelancer's Global Interview Standards The presentation is to be around 15 to 20 slides in length. I have highlighted in blue in the below presentation document, the titles I want you to focus on creating for the slide deck. Please feel free to use images wherever necessary. Key requirements: - Creating a visually-engaging, professional slide deck - Incorporating provided branding guidelines - Ensuring the slides are clear and concise - Good project management and communication skills, as I aim to be involved in the process to ensure it aligns with my vision
Hi I'm about to advertising a learning course. I will be delivering the course by zoom ov...course materials, and interact with the course participants. A draft of the course information is attached. I'm looking for a freelancer who can support me with my Moodle platform. I have never used moodle before, so I need help with installation and setup, and ensuring that our required functionality is possible. I am working with an assistant and we both need to be able to access the participant forums to respond to queries, and to upload and receive materials. Please provide a succinct proposal, and an expectation of how long this would take. I am after a very simple solution at this stage, as the moodle element is only for communicating with participants, ...
...Make about 5-10 API/country for installing python, setting SQL for our applications and Google Sheet. For each country may need API for such as : 1. Historical Data 2. Financial Scrapped Source 3. Financial Summary Scrapped Source 4. Interest rate 5. Some More Required Skill & Experience : 1. Php & SQL 2. Familiar with python installing & setting up environments 3. Experienced in Linux Debian & LNMP server by SSH 4. You need to know on how to run python scripts on debian by ssh, and setup cron task on debian, and debugging etc Personality's Criteria : 1. No toxic working environment 2. Agile, Responsive, and Fast Delivery 3. Collaborative as a team 4. Responsible, Credible, Reliable and Integrity person 5. No agency, only...
I'm in need of an experienced developer or agency to create a custom assessment platform, similar to Coderbyte/ Hackerrank tailored to my specific needs not limited, but similar to . Here's what I'm looking for: 1. AI-Generated Code Assistance** - **Smart Code Suggestions**: Implement AI algorithms that provide real-time code suggestions and auto-completions similar to tools like GitHub Copilot. - **Code Snippets**: AI can suggest commonly used code snippets based on the problem statement and context. - **Problem Solving Hints**: AI can offer hints or guide candidates through difficult problems without giving away the solution. - **Adaptive Learning**: Use AI to adjust the difficulty of questions based on the candidate's performance in real-time. ### **2. A...
...features and requirements: Primary Functionality: - Users should have the ability to create their own accounts, which is crucial for creating a personalized shopping experience and tracking orders. - The app must support in-app purchases, as it is central to the shopping functionality. - Incorporating a live chat feature will enhance customer service, providing users real-time support and interface for queries and concerns. Ideal Skillset: * Strong proficiency in iOS and Android app development. * Past experience designing e-commerce apps. * Experience in incorporating in-app purchases and live chat functionality is preferred. * Knowledge in user-interface design for retail mobile apps. The perfect candidate should have a proven track record in developing...
We are looking for someone long-term who can do cartoon animation with experience in video editing. It will be around 1-2 minute per video. These will be for youtube. We are looking for someone good in communication, can do it on a good price, and delivery time. More details will be provided upon interview.
I'm in need of a web designer and developer who can create a new website for my business. While I have a logo, I don't have a predetermined color scheme. The website will be an information hub about my business, hence no e-commerce functionality is required. Key Features Needed: - Contact Form: The site should have a user-friendly contact form for easy interaction with visitors. - Gallery: A gallery to exhibit my business' work or products is a must. - FAQ Section: An FAQ section is necessary to address common queries and to provide better understanding of my business. As the designer/developer, you'll need to be creative with colors (drawing inspiration from the logo), and ensure that the website is clean, professional, and easy to navigate. Ex...
...carry out multiple tasks: - Answer typical queries - Offer relevant advice - Schedule meetings - Perform any function that is currently possible for it to do verbally The AI chatbot should be compatible with Slack and eventually extend to all phone applications. The chatbot should integrate with a database. We could explore other data integration requirements during our discussions. Ideal applicants are those familiar with AI chatbot programming, Google Assistant integration, and broad-reaching app compatibility. Database integration knowledge is essential, with bonus points for those who can offer a variety of data integration possibilities. Please bid only if you are skilled in these areas and ready to collaborate on this task. 'm looking for a sk...
...`11_bkntc_services` table in the database. (I use the Booknetic Plugin for Game Bookings) The table looks like this image, so you will have to use case insensitive SQL to find the `11_bkntc_services` WHERE name is PARTIALLY equal to the "Projects name" (2nd Image) as I have multiple actual games per "Project" The WP page in question is Https:// The "Book Now" button uses the code in the image below found in this file: wp-content/themes/gamico/template-parts/project/ to show the Booknetic category based on the game. ----------------------------------------------------------------------------------------------------------------------------------------------------------------- Ideal skills for this project: - Strong experience with WordP...
...tax filing for both US and Canada. I am a dual citizen of Canada and the USA, having obtained my US citizenship in 2020. Due to a recent move to Arizona and plans to sponsor my wife for her green card, I have discovered the need to file my Canadian taxes with the USA. I require an experienced and licensed accountant who specializes in both US and Canadian tax laws, particularly for dual citizens, to get my taxes in order promptly. Responsibilities: File Canadian tax returns for the years since obtaining US citizenship in 2020. Ensure compliance with both Canadian and US tax laws and regulations. Provide accurate and timely filing of all necessary documents. Assist with any additional tax-related queries or issues that may arise during the process. P...
Requirements: - Vuejs, Nuxtjs - Tailwind CSS - Supabase/PostgreSQL - Nodejs/Deno - Typescript - Responsive Design - Maintainable and readable code - APIs - Authentication, Authorization, Roles & Permissions - Docker - Bonus: Tests Job: - Program members portal (tasks, events, payments, backoffice) - Blog & Blog backoffice with - Create and use queries and mutations - Newsletter: manage emails and newsletter backoffice (sendgrid and others) - Manage registrations (calendly like) 12 Pages: - Portal Login - Registration - Portal Dashboard - Portal Events - Portal Tasks - Portal Profile - Portal Settings - Portal Payments - Backoffices - Blog Main - Blog Single - Others
...skilled freelancer to implement Continuous Integration and Continuous Deployment (CI/CD) using GitHub Actions, set up logging for each service, and configure an HTTPS domain for our web application hosted on Google Cloud Platform (GCP). The ideal candidate should have extensive experience with GCP, CI/CD pipelines, and HTTPS configuration. Scope of Work: 1. CI/CD Implementation: - Set up a CI/CD pipeline using GitHub Actions for automated testing, building, and deployment of both frontend and backend applications. - Integrate the pipeline with our GCP infrastructure, including Compute Engine, Cloud SQL, and Cloud Storage. 2. Logging Setup: - Configure logging for all services: -- Frontend (Nginx, ): Log HTTP requests, errors, and application logs. ...
use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days you provide code to simulate input data (both code versions: python and sql)-> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78, 5, 23, 41. When 34 for 20%; 65 for...
I'm in need of an English-Portuguese interpreter in Elvas, Portalegre, Portugal for an important in-person marriage interview. Key Requirements: - The interview is expected to last for less than 1 hour. This is a crucial detail to bear in mind. - The interpreter must be able to translate Portuguese to English and vice versa. It's essential that they are proficient in both languages. - Knowledge of legal terms is a must, as the interview will involve legal discussions related to marriage. Ideal Skills and Experience: - Fluency in both English and Portuguese is a prerequisite. - Prior experience with legal terminology and processes will be highly beneficial. - Previous experience in translating during marriage interviews or similar situations w...
We are looking for 5-10 years of .Net experienced developer who can also have experienced in React and .Net based web development. Long terms multiple projects development. Using Mainly Azure SQL server database with Visual Studio .Net Core API. Graph QL and EF. Worked on Azure Key Vault, Azure Logic app, Azure function is bonus.
...Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days *****you provide code to simulate input data -> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states randomly 30 to 170 transactions per day for given product for usual price randomly 200 to 600 transactions per day for given product for promotion random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, ...
