Sql queries examples with answers ppt punët

We have 2 SQL databases. A source database and a target database that have completely different structures (tables, field names/types and relations). We're doing some migration planning from source to target and need some consulting advice on how to best map tables and fields for ETL migration. We are looking for a solution that uses AI and/or ML to avoid doing this all manually the schema mapping. Please put "SCHEMA123" at the start of your proposal so we can filter out automated responses. Please list any details of your experience in doing a project like this. Thanks!

I run a contracting business, building out the inside of grow rooms, installi...out the inside of grow rooms, installing all the equipment, Irrigation systems, rolling tables, lights, dehumidifiers, humidifiers, drains, fans.. everything! … I’m looking for a designer to help gives us a design as a physical representation of the layout of the pipes and where the irrigation systems placed, all the tanks piped in, pump placement, along with a material list, I will attach some examples I need an expert who can help with the overall design layout, including light and table placement, equipment positioning, and irrigation system design. Key requirements: - Design an efficient light layout - Strategically plan table and equipment placement - Create a reliabl...

I'm in need of professional structural drawings for a wooden shed roof, specifically designed for plywood. These drawings are intended for submission to acquire a building permit in Florida. Ideal Skills: - Expertise in structural engineering and design - Proficiency in creating detailed construction drawings - Familiarity with Florida's building codes and permit requirements Requirements for Proposal: - Examples of previous similar projects - An outline of your understanding of the project - Proposed timeline for completion

I'm looking for a seasoned professional with advanced knowledge in SQL database architecture. The primary task will be designing a new database. Ideal Skills and Experience: - Extensive experience with SQL - Proven track record in database design - Ability to understand and meet project-specific requirements - Strong problem-solving skills - Excellent attention to detail

...based on multiple key metrics. These ratings will assist in matching properties with clients based on their unique investment preferences. Key Features: 1. Data Integration: • Pull data from external sources related to property market trends, pricing, yields, growth potential, and more. 2. Data Cleaning and Processing: • Clean and process the data to ensure it’s ready for analysis and reporting. 3. Property Rating Calculation: • Calculate property ratings using multiple factors (e.g., price, yield, demand, growth potential, etc.). • Customize ratings based on individual client preferences (e.g., focusing more on return on investment or potential for growth). 4. CRM Integration: • Integrate the system with an existing CRM to display ...

I'm seeking a Python developer with experience in trading tools. I need a program that scans stock market data from the NSE FNO. The scanner should filter stocks based on price movements and technical indicators. Key Requirements: - Proficiency in Python - Experience with trading software development - Ability to create a scanner that exports results in .csv format Ideally, the freelancer will have a good understanding of stock trading and technical indicators. Please include examples of relevant projects in your bid.

...data streaming with a focus on low latency. Key Responsibilities: - Set up a new Deribit Test account and generate API keys for authentication - Implement order management functions, including placing, canceling, modifying orders, getting the order book, viewing current positions - Develop a WebSocket server functionality for real-time market data streaming - Allow clients to subscribe to symbols and stream continuous order book updates for those symbols The ideal candidate should have: - Profound expertise in C++ programming - Prior experience working with trading systems - Familiarity with WebSocket server implementation - Understanding of low latency requirements in trading - Capability to handle all parameters during order modifications Please ensure to provi...

Seeking an experienced ZebraDesigner professional to create and troubleshoot new barcode label designs. Labels will contain product details, serial numbers, and batch numbers. Ideal candidates should be: - Proficient in ZebraDesigner - Bilingual: Fluent Spanish speaker - Experienced in creating barcode labels - Skilled in troubleshooting design issues Please provide examples of relevant past work and your level of proficiency in Spanish.

I need a WordPress expert familiar with the KvCore Plugin. - Search Filter Layout: I want to change the layout of the search filters. The website is , I want the filters to look like they do on - 'Back to Search' Button: I need to modify the functionality of the "Back to Search" button. It currently takes you back to a generic search, I would like it to take you back to the previous search that you can from. The ideal freelancer for this job would have: - Extensive experience with WordPress and the KvCore Plugin - Strong skills in web design and user interface layout - Ability to customize button functionality Please provide examples of similar projects you have completed.

I'm seeking a professional to set up Instagram and Facebook ads for my beauty business. The primary goal of these ads is to generate leads. Key Requirements: - Comprehensive understanding of Instagram and Facebook ad systems - Proven track record of lead generation through social media ads - Experience in the beauty industry is a ...Facebook ad systems - Proven track record of lead generation through social media ads - Experience in the beauty industry is a plus - Ability to target and reach a national audience - Proficiency in targeting specific demographics, particularly adults aged 26-50 I wish for the ads to be engaging, appealing and tailored to attract potential leads within the specified demographic. Please include examples of your previous work and results achieved in...

My WordPress site has a broken registration process. Users are experiencing incomplete registrations. I need a professional to diagnose and fix this issue. Key tasks: - Diagnose and repair the registration process - Implement security measures to prevent fake user hacks Ideal skills include: - Expertise in WordPress - Proficient in website security measures...Users are experiencing incomplete registrations. I need a professional to diagnose and fix this issue. Key tasks: - Diagnose and repair the registration process - Implement security measures to prevent fake user hacks Ideal skills include: - Expertise in WordPress - Proficient in website security measures - Strong problem-solving skills It would be preferable if you could provide some previous examples of similar work you ...

Project Brief for Rise & Close Branding Overview: Rise & Close is a modern, relatable newsletter designed for Gen Z professionals in sales and marketing, particularly SDRs (Sales Development Representatives) and aspiring salespeople. The brand focuses on empowering young professionals with actionable strategies for career success while emphasizing the importance of physical and mental well-being. Brand Values: Empowerment: Helping readers take control of their careers and lives. Growth: Encouraging a mindset of continuous improvement and learning. Balance: Promoting the importance of physical and mental health in achieving success. Relatability: Speaking directly to the challenges and aspirations of Gen Z professionals. Actionability: Providing practical, immediately usable...

I'm in need of a professional who can create a web-based data entry tool for a MySQL database. This tool will handle mixed data types: text and numerical. The primary functions of the tool will be to facilitate data input and conduct validation checks. See attached file for specifics. Key Requirements: - Proficiency in MyS...types: text and numerical. The primary functions of the tool will be to facilitate data input and conduct validation checks. See attached file for specifics. Key Requirements: - Proficiency in MySQL database management - Experienced in web-based application development - Prior work on data entry and validation tools - Understanding of both text and numerical data processing Please include examples of similar projects you've completed in your ...

I'm looking for a skilled photo editor who can enhance my water bottle images for Amazon. The main edits I need include: - Background removal: The images should have a clean, professional look with the background removed. - Color Correction: The images need to be color corrected to ensure the water bottle looks its best. - Adding Text or Graphics: I will need some text and graphics added to certain images, so experience with this is a must. All edited photos will be used for a product listing, so they need to meet Amazon's photo requirements. Please provide examples of similar work you've done in the past.

Project: Installation and Customization of Frezka Salon Management System for Lotus Flower Overview: We are looking for a skilled freelancer to set up and customize the Frezka salon management system (built with Flutter and Laravel) on our server for our Lotus Flower brand. The system will serve as a centralized solution for managing appointments, staff, and operations across multiple branches. Additionally, we require specific customizations to enhance functionality for our business needs. Scope of Work: Installation and Initial Setup: Install the Frezka salon management system on our server. Configure the system to operate under our brand name, Lotus Flower. Ensure proper integration and functionality for multiple branches. Customization Requirements: Expense Management: Add a ...

I'm looking for an Excel expert who can help me build a comprehensive report showing Actuals vs Budget vs FC vs PY. The report will primarily serve as a financial overview tool and needs to be updated daily. Key requirements include: - Proficient in Excel with advanced skills in data analysis and visualization. - Experience working with internal databases and external data feeds. - Ability to understand and interpret financial data. - Capability to create automated daily updates for the report. Please include examples of similar projects you've completed in your proposal.

I'm looking for a professional who can help me model a conceptual stage residential project in SketchUp. - You'll need to modify existing 3D models with proposed changes. - The level of detail required is basic, focusing on the structure and layout, rather than the interior or exterior details. Ideal candidates will have extensive experience with SketchUp and a strong understanding of residential architecture. Please include examples of previous similar projects in your bid.

...showcasing platform highlights. Options to sign in, sign up, or continue as a guest. Menu with sections: Products, About Us, Portfolio, Branches, and Client Portal. Product browsing with category filtering and portfolio examples. Checkout process with a questionnaire (except for Social Media and Software Development services, which are redirected to the sales team). Client Portal (Web & Mobile): Manage orders, subscriptions, and invoices. Track social media services (platforms, post count, photoshoot dates). Monitor software development projects (milestones, due dates, calendar, training). Schedule meetings and access live chat support. Profile management and logout. Employee Portal (Web Only): Dashboard with task statistics, bonuses, and product...

I'm looking for a talented videographer with experience in creating engaging promotional content for social media. Key Requirements: - Experience in shooting and editing live-action videos - Ability to create content that increases brand visibility and engagement on social media - Understanding of the specific requirements and best practices for different social media platforms Your proposal should include examples of similar projects you have completed in the past. Must be able to shoot in Kuala Lumpur. We are a non profit NGO

I need a double sided A6 leaflet designing to explain how my garage deals with insurance claims. I have the text I need on a photoshop file as well as my logo in various formats, but need someone to arrange it and add graphics to make it look sleek and professional Key Requirements: - Arrange textual content on the leaflet - Integrate my logo and branding elements - Add appropriate graphics and photographs Ideal Designer: - Has a modern and clean design approach - Prior experience in corporate and professional leaflet design - Able to source and incorporate appropriate generic photographs from the internet You will have the freedom to select colors and design elements, as I am open to your creative suggestions. The goal is to create a leaflet that communicates our insurance claim...

I'm in nee...monitoring, and delivery status updates. The site must provide users with real-time updates on their deliveries and the status of drivers. - Payment Integration: The site needs to support multiple payment methods. This includes Credit/Debit card, PayPal, and Bank Transfer. The payment system must be secure and user-friendly. Ideal Skills: - Web Development: Expertise in creating interactive and user-friendly websites. - Logistics Knowledge: Understanding of the logistics and delivery sector will be an advantage. - Payment Integration: Proficiency in integrating various payment systems into a website. - Real-Time Tracking Systems: Experience with incorporating real-time monitoring features into a website. Please provide examples of similar projects ...

I'm looking for a professional and sleek social media poster to be used primarily on Instagram for product advertisement. Key Requirements: - Design should be modern and sophisticated - Use of ...for product advertisement. Key Requirements: - Design should be modern and sophisticated - Use of clean lines and minimalist aesthetics - Ability to effectively communicate brand message through design - Experience with Instagram's visual style and requirements Ideal Skills: - Graphic Design - Branding - Social Media Marketing - Understanding of Instagram's platform and its audience The poster should not only reflect a professional and sleek style but should also grab attention and promote the product effectively. Please provide examples of your previous work tha...

I'm in need of a classic style honey jar mock-up in Photoshop. The mock-up should be comprehensive, featuring the lid design and an appropriate background setting. Ideal Skills and Experience: - Proficiency in Photoshop and 3D modeling - Strong design skills, particularly in classic style - Experience in creating product mock-ups - Ability to create realistic background settings Please include examples of similar projects in your bid.

I'm seeking a skilled video editor to help me remove names from an MP4 Zoom recording. The names are static and appear throughout the entire video. Key Requirements: - Expertise in video editing, especially with MP4 files. - Ability to seamlessly edit out text so the transformation is completely unnoticed. - Attention to detail to ensure the final product is clean and professional. Please provide examples of similar projects you've completed in your bid. There are in total about 10 videos ... but the process is exactly the same for all.

I'm looking for a skilled Power Apps developer who can assist in building a Power App primarily for workflow automation. The specifics of the processes to be automated have not been finalized, so flexibility and a proactive approach are key. Ideal Skills: - Proficient in Power Apps - Experience in workflow automation - Strong problem-solving abilities - Exc...primarily for workflow automation. The specifics of the processes to be automated have not been finalized, so flexibility and a proactive approach are key. Ideal Skills: - Proficient in Power Apps - Experience in workflow automation - Strong problem-solving abilities - Excellent communication skills Experience: - Prior projects involving Power Apps - Successful workflow automation projects - Examples of proactive proj...

Ju lutemi Regjistrohuni ose Identifikohuni për të parë të dhënat.

I'm seeking a seasoned Flutter developer to help me create a compelling mobile e-commerce app. Key Features: - Product Catalog: The app should be able to showcase a diverse range of products in an intuitive and user-friendly manner. - Sh...experience is crucial. The cart should be able to handle various operations like adding/removing items, updating quantities, etc. - Payment Gateway Integration: The app needs to be able to securely process transactions through reliable payment gateways. Ideal Skills: - Extensive experience with Flutter framework. - Strong understanding of e-commerce app development. - Proficient in integrating various payment gateways. - Knowledge about creating an interactive product catalog and shopping cart. Please provide examples of your previo...

I'm in need of a skilled web developer to create a comprehensive ...online courses. - User Registration and Profiles: A user-friendly registration process is essential, along with personalized profiles for each user. - Blog and Articles Section: The site needs an integrated blog to share articles and updates. - Freelance Section: A dedicated space for freelancers is required, allowing for interaction and collaboration. The ideal candidate for this project should have a strong background in web development, with specific experience in creating educational platforms. A keen understanding of user interface design and e-commerce (even though this project does not currently require a specific e-commerce platform) would be beneficial. Please provide examples of similar...

I'm looking for a professional with AutoCAD experience to help me create a general arrangement plan for laying a telecommunication submarine cable. The project requires two views: a plan view and a side view, both to be designed in A3 size using a standard template. We need the drawings by today itself. Key Requirements: - Create a layout that takes into account various underwater terrains. - Deliver final designs in both DWG and PDF formats. - Use of a standard A3 size template. - High attention to detail and precision in design. - Prior experience with submarine cable layouts is a plus. Please include relevant examples of your previous work in your bid.

...need of a skilled developer with extensive experience in Hyperledger Fabric, specifically focusing on the creation of smart contracts for supply chain tracking. Key Responsibilities: - Design and develop smart contracts that facilitate supply chain tracking - Implement features for real-time updates, transaction history, and automated alerts Ideal Skills: - Proficiency in Hyperledger Fabric and smart contract development - Experience in supply chain management systems - Strong understanding of blockchain technology and its applications in tracking and tracing assets Please note, the project revolves around the development of smart contracts that need to be efficient, reliable and capable of handling complex supply chain scenarios. Your previous work examples in this do...

I'm looking for an experienced React Native developer to build an iOS app for me. The app should include the following functionality: - User Authentication: The app should have a secure login system using email and password. The ideal freelancer for this project should have a strong background in React Native and iOS development, with proven experience in implementing user authentication systems. Please include examples of similar projects you've completed in your bid.

Website Revamp with New UI/UX Design I need a complete redesign of my current website with a new UI/UX but keeping all functionalities and links to the same database. The new design should align with the provided Figma prototype (but with old website data and sections and with new design) in terms of colors and modern aesthetics, with an emphasis on ease of navigation and responsiveness. old web site: figma design: Key Requirements: - All components from the old site must be retained

...Diversification Essay I need an essay of 2,500 words on two topics relating to finance and investments. 1) Using illustrative examples, distinguish between the interest yield and the redemption yield of a bond, and discuss the likely consequences for the above yields if the default risk of a bond increases. 2) Show, using a hypothetical example, how diversification can reduce portfolio risk and analyse how dependent is the effect of such diversification on the coefficients of correlation between returns on the various securities in the portfolio. The essay should adopt a balanced approach of both theoretical explanations and practical examples, written in a formal academic style with an introduction, body and conclusion. Please note: - A comprehensive understand...

I need an essay of 2,500 words in total on two topics relating to finance and investments. 1) Using illustrative examples, distinguish between the interest yield and the redemption yield of a bond, and discuss the likely consequences for the above yields if the default risk of a bond increases. 2) Show, using a hypothetical example, how diversification can reduce portfolio risk and analyse how dependent is the effect of such diversification on the coefficients of correlation between returns on the various securities in the portfolio. The essay should adopt a balanced approach of both theoretical explanations and practical examples, written in a formal academic style with an introduction, body and conclusion. Please note: - A comprehensive understanding of the time ...

I'm looking for an Excel expert to create a macro that will help in task automation. The specific tasks to be automated will be discussed later. Ideal Skills: - Proficiency in Microsoft Excel - Experience in developing macros for task automation - Excellent problem-solving skills - Ability to understand and analyze tasks for automation Please provide examples of similar projects you've completed in your proposal.

I'm seeking an exam invigilator with at least a Bachelor's degree to administer an on-site exam in Manma, Bahrain. This is a one-time gig with the potential for future opportunities. We provide test administration and accommodation solutions to test-takers worldwide. For this purpose, we look for professionals who we contact on an "as-needed" basis to see if they are available to assist test takers for their approved accommodations. We provide complete training and assignments pay hourly for the entire scheduled time, even if the exam ends early. We have a computer exam coming up where a test taker has been approved for Reader and Recorder. This where you read exam content aloud to the test taker and then enter the answers as they direct. The exa...

I'm looking for an experienced WordPress web developer to create a secure, user-friendly site for my pre-recorded class videos. This site should allow for: - User Registration: With secure login, password recovery, and subscription management. - Payment Integration: Primarily through Credit/Debit Cards for monthly subscriptions. - Content Upload: Enabling me to upload my pre-recorded classes and instructional videos. The subscription system should be simple: it renews each month with the corresponding payment. I can provide examples of sites I would like to model this one after.

I'm in need of a skilled dressmaker to sew a casual, chiffon, maxi-style dress for me. Ideal Skills: - Expertise in sewing and dressmaking - Experience working with chiffon fabric - Ability to create a maxi-style dress Please provide examples of your previous work with similar dresses.

I am looking for a professional website designer with extensive experience in e-commerce and specifically in designing coaching websites. The primary purpose of this website is to facilitate the booking and payment for coaching sessions. Key Requirements: - A fully functional booking system: This should allow users to schedule sessions seamlessly. - A secure and reliable payment gateway: This is crucial for processing payments for the coaching sessions. - A testimonials page: This will help build credibility and trust with potential clients. Ideal Skills: - Expertise in e-commerce website design - Proficient in creating and integrating booking systems and payment gateways - Experience in designing testimonials pages - Familiarity with SEO and responsive design - Str...

One week to make a professional style website for a new restaurant and it's opening. Something a bit quick and easy but the above are a couple examples

...values: creativity, quality, boldness, trust, empowerment, and authenticity. Business cards with a modern yet retro twist. Social media templates that align with our brand. A cohesive website design combining retro and modern aesthetics. Our Style: We want branding that stands out and showcases our unique style—a perfect blend of retro and modern. To help inspire you, we’ve put together a moodboard: [Insert a link to your moodboard here]. Budget: Our budget for this project is up to $900 USD. Future Collaboration: If the collaboration goes well, we’d love to work with you on future projects for our clients and other creative endeavors. How to Apply: Please send us: Your portfolio (including examples of branding or visual identity project...

I'm looking for a professional to create a detailed business expense report for me. The report should be in a spreadsheet format, specifically Excel or Google Sheets. I have the spreadsheet template already and need help entering the data and attaching the receipts. Key Requirements: -Enter the receipt data, vendor, amo...receipt data, vendor, amount, location and distance from 4314 Airport Blvd, austin tx. Need the receipts copied then attached or attached in some way. - The spreadsheet should be well-organized by month, easy to navigate, and ready to submit for approval. Ideal Skills: - Strong proficiency in Excel or Google Sheets. - Excellent attention to detail. - Previous experience with creating business expense reports. Please provide examples of similar proj...

I'm seeking a seasoned Ruby on Rails developer for the maintenance and updates of an existing Business Services web application. The system is designed to manage client details, documents, and operations. Key Responsibilities: - Regular maintenance and updates of the web application - Ensuring system efficiency and functionality Ideal Skills: - Proficiency in Ruby On Rails - Experience with Docker and SQL - Previous work on Business Services systems Please note, the selected developer must be contactable and able to work during UK standard office hours.

I need a skilled developer with expertise in PayPal Payments Pro integration to implement comprehensive payment solutions on my custom-built online education marketplace. Key Requirements: - Implement PayPal Payments Pro for seamless transaction processing. - Set up payment systems for both subscriptions and one-time purchases. Our website will also take Stripe payments but this is not part of your project. Ideal Skills: - Proficiency in working with custom-built platforms. - Prior experience with PayPal Payments Pro integration. - Understanding of online marketplace dynamics and payment requirements. Please provide examples of similar projects you have completed in your bid.

I'm looking for a seasoned software developer to create a robust Desktop Pharmacy Management System specifically for Windows OS. This system will serve multiple functions, including Point of Sale (POS) for pharmacies, buying, selling, and managing inventory with expiry date filters. The system should support barcode scanning for both selling and stock management, and should be able to store all medications and their details. Key Features: - Comprehensive inventory management with quantity tracking and expiry date filters - POS functionality for seamless selling processes - Barcode scanning capabilities for both selling and inventory management - Storage and retrieval of all medications in the system The system should also integrate the following additional modules: - C...

I'm seeking a seasoned Android(Kotlin) & iOS(Swift) Developer, boasting a minimum of 6 years experience, to build a dynamic Android application. Key Requirements: - Extensive...functionalities - Mastery of implementing OAuth for user authentication, primarily through Google and Facebook. The primary feature of this application will be its social media integration. It should allow seamless sharing and connectivity with the aforementioned platforms. The ideal candidate will have a proven track record in developing engaging, user-friendly Android applications with robust social media capabilities. Experience in implementing security measures for OAuth and creating a smooth, secure user authentication process is essential. Please include examples of previous, s...

...first leads after onboarding. 6. Tracking and Reporting: - Explain how you will track, monitor, and report on campaign performance. - Tools and dashboards used to share insights and progress with our team and clients. - KPIs to measure success (e.g., cost per lead, conversion rates). 7. Adaptability: - Describe your ability to adapt to different solar markets (e.g., residential, commercial, rural areas). - How will you stay up-to-date with solar industry regulations, rebates, and incentives to ensure campaigns remain compliant and competitive? 8. Case Studies or References: - Share examples of previous successful solar lead generation projects or campaigns you’ve worked on. - References or testimonials from past or current clients in the solar industr...

...for commission distribution and affiliate activity tracking. Scope of Work: Affiliate Commission System: Configure a 3-tier commission structure with fallback logic for unclaimed commissions. Ensure proper integration with ticket sales or product purchases. Custom Logic Implementation: Develop conditional logic for affiliate commission eligibility based on activity thresholds. Implement fallback handling for inactive or missing affiliate tiers. Dashboard Customization: Customize affiliate dashboards to display key metrics, including sales performance, commission breakdown, and eligibility status. WooCommerce/Event Integration: Integrate with WooCommerce or a similar platform to ensure ticket or product purchases trigger the appropriate commission logic. Tes...

...supplements and medicines. The website should take inspiration from , featuring a clean, modern design and detailed product listings. Key Features: - Product Listing: Comprehensive product pages with detailed descriptions and well-structured categories. - Secure Transactions: Integration of a reliable and secure payment gateway. - User Account Management: Incorporation of a system for tracking order history. - Regulatory Compliance: The site must meet all USA regulations for online medicine sales. Please share your portfolio, examples of similar projects, estimated timeline, and budget. A successful high-quality delivery tailored to these specifications is paramount. Don't hesitate to reach out for any clarifications or questions. I look forward to potentially