Sql query parent levelJobb

Hej Amr S., jag la märke till din profil och skulle vilja erbjuda dig mitt projekt. Vi kan diskutera detaljerna över chatten.

Till en nygrundade företag inom social entrepreneurship behövs det skaffas en SQL databas samt back-end mask till data query och entry, och en mindre front-end sökmask. Detailerad lista på databas-råder och egenskaper såväl som mockups på aller masker finns. Webspace med möjlighet till SQL databas finns. Detta är prototyp-stadien till en större projekt och rätt programmerare kan blir anlitad även till vidare arbeten med databasen, back- och front-end maskarna, samt senare utveckling av sökmask i app-form och enkelt web-shop kopplad till databasen.

We need help with Facebook advertising for our customers. We need you to do the advertising through Ad Manager (not using "boost" button) and also to have a passion for and experience in copywriting. You need to have experience with creating successful Facebook Ads. Let´s start by testing once and if we get good results this can...advertising for our customers. We need you to do the advertising through Ad Manager (not using "boost" button) and also to have a passion for and experience in copywriting. You need to have experience with creating successful Facebook Ads. Let´s start by testing once and if we get good results this can become a long term cooperation, where the tasks can later expanded. You will get access to high level training material in...

Jag behöver en databas (SQL script) som håller reda på Medlemmar och dess Vänner, samt Kontakt/Meddelanden som skickas mellan dem: - Medlemmar (Namn, Mail, Lösen, Mobilnr., inloggningssätt (Facebook, Google, ösen)) - Medlemmars olika relationer till Vänner (mobilnr., mail, namn, adress) - Tabell över kontakter/meddelanden som tagits med Vänner (GUID skapas för varje gång). - Möjligheter för Vänner att logga in med hjälp av GUID för att se meddelanden - Meddelande skall kopplas mellan Medlem och Vänner. - Medlemmarna skall kunna ha en elektronisk plånbok

Jag har skrivit en säljande konsument guide om öl som behöver skrivas om. om du är intresserad är det

Project 1av 2(sql fler fields) skickar den andra projektet under dagen Har ändrat pattern1&pattern2 columnerna i databasen till kundnr&country, id till uid, verkar fungera. Sedan har jag ändrat field1&2 till flera columner i results.html. Så här ser columerna ut i databasen. id, kundnr, country, searchstring, tiff, checked, vat_number, company_name, company_adress, invoice_date, invoice_nr, valuta, summa_netto, summa_moms, varukod, varu_underkod, sprak_kod, beskrivning, fakturatyp, skattenummer

Mac PHP Har byggt en första version av en sajt som låter användare logga in och ange/ladda upp data. PHP/Mysql är använt idag. Skulle i dagsläget behöva primärt ett bollplank kring databasstruktur och koden principiellt men även hjälp med faktisk programmering för vidareutveckling av tjänsten. säkerhetsaspekter är också viktiga i nuläget

Söker back end utvecklare med erfarenhet från skräddaranpassade CMS hemsidor. Du bör vara kunnig inom PHP, Web 2.0, XHTML, SQL, Cross-browser optimering. Utvecklingen av hemsidan bör göras med stor anpassning. Då majoriteten av publiceringen görs av redaktörer måste backend vara anpassad för exempelvis skapande av artiklar. Du kan utgå från ett open-source alternativ och vidareutveckla den enligt våra specifikationer. Integrering mellan hemsidan och databas måste göras av dig. Analytics program erfordras. Interaktion görs möjligt med commenting, threads och forum. Erfarenhet från schemaläggning av aktiviteter bör du kunna göra. Caching även. Säke...

Programmering av ett Iphone och Android telefonapplikation kopplat mot telefonväxel MS SQL och winows server. Funktion och design ingår. Erfarenhet av applikation som contact center, callcenter. Samtalsstryning och design. Lång erfarenhet och stor förståelse krävs.

Programmering av ett Iphone och Android telefonapplikation kopplat mot telefonväxel MS SQL och winows server. Funktion och design ingår. Erfarenhet av applikation som contact center, callcenter. Samtalsstryning och design. Lång erfarenhet och stor förståelse krävs.

Programmera ett Ticket och support system i Filemaker pro. Ärende, med service level agreement. Mail automatsikt, webchat, Web gärnsnitt för kunden. Telefonsamtal ska loggas och samtalshistorik per kund. Statistik. Schema planering via kalender integrerad med outlook. Fakturering. Sökande ska vara utvecklare i Filemaker med flera års erfarenhet Referensprojekt och dokumenterad kunskap.

I need assistance with typing a series of literary texts in Hindi. The project entails taking scanned documents and retyping them in Hindi. For the project, a basic level of proficiency in Hindi is required. Key Requirements: - Hindi Typing: You need to have a good typing speed and accuracy in Hindi. - Basic Hindi Proficiency: The job involves typing literary works, so a basic understanding of the language is necessary. - Attention to Detail: Precise typing is essential to ensure the integrity of the original documents is maintained. Prior experience in data entry, Hindi typing, or similar projects would be advantageous. The project is quite straightforward, and the ideal freelancer should be able to complete it within a reasonable timeframe.

I am in need of a tutor with an intermediate level understanding of Finite Mathematics, to assist me with my course work. The specific topic focus I require guidance on, has been left open to include Sets and Counting, Probability, and/or Linear Equations, depending on the freelancer's area of expertise. Ideal Skills Include: - Understanding of various Finite Mathematics topics - Proven tutoring skills - Experience with teaching or tutoring in these areas - Ability to explain complex mathematical concepts in a simplified manner Please include in your proposal: - An outline of your experience with Finite Mathematics particularly in Sets and Counting, Probability, and/or Linear Equations. - Your teaching methodology - Your availability and proposed schedule This is a great opp...

I'm in need of a logo for my blog which delivers profound life lessons motivating others. The ideal candidate will create an outstanding logo which reflects the earthy and natural colors that I envision for my blog. As a designer, your skills should include: - Master level knowledge of Adobe Creative Suites, - Experience in designing logos for blogs, - Ability to create concepts based on the narrative given Your task will be to incorporate abstract shapes into the logo. A knack for creating abstract and engaging visuals is a plus. A portfolio showing similar work would be beneficial.

I need an experienced data scientist or AI specialist to assist with evaluating a Korean dataset using OpenAI API calls. my goal is to set up a good testing template I can repeat Key Aspects: - Inference Speed: Achieving a balance of optimal inference speed is vital for this project. The desired inference speed for the evaluation stands at a moderate level when considering 2000 users. - Total Processing Accuracy: I'm looking to ensure the total processing accuracy of this evaluation is high. - TPA (Total Processing Accuracy): Aspects of TPA are crucial for this project; we aim for a balanced importance between total processing accuracy and inference speed. - Implement this on a shared googleColab or Jupyternotebook for on-demand use of the application Ideal Skills and Experie...

I'm looking for a talented writer to create short, highly technical articles on various technology topics. The ideal candidate will posses: - An in-depth understanding of technology and the ability to write about it in an engaging and accurate manner. - Proficiency in writing concise, expert-level content. - A proven track record of creating engaging technology blog articles. I'm looking for short, well-researched articles that can provide valuable insights to an expert audience.

I am a builder, looking for a creative graphic designer to bring to life 3D facades for my projects. I will provide the elevations of my plans, your task is to generate modern, intermediate detailed 3D facades. Key tasks and specifics: - Create modern-style facades - Apply intermediate deta...Ideal skills: - Proficiency in 3D modeling and graphic design - Strong understanding of architectural design, particularly modern house styles - Familiarity with materials, particularly wood, and color schemes in neutral tones - Previous experience working with builders or in the construction industry would be beneficial Please ensure your portfolio showcases similar projects to the style and level of detail I anticipate. I am excited to see how you can turn my plans into beautiful, modern 3...

Seeking sales oriented freelancer to help our charitable organization raise funds to supply medical equipment to people in need in Israel (for starters). We are a USA charity, registered with the IRS. We have a website and payment portal ready. We also have initial marketing being carried out with The Times of Israel. Eventually, we will ... In addition to the human qualities described above, it would be wonderful if you are comfortable or even progressive in the online world so that our Project Mobility can benefit from up-to-date thinking about the technology that we use for digital outreach. We are certain that room exists for a creative dynamic to drive us forward. This is a wonderful opportunity on a financial and human level. You will be doing good, and will be amply...

Necesito alguien que puede dar un curso de power Bi en 10 sesiones en total 15 horas por sesion es de 1 hora y media, 2 sesiones por semana martes y jueves de 4 a 5:30 de la tarde hora Guatemala. Empezando 23 de abril y terminando 23 de mayo. Alrededor de 15 personas, las sesiones son por google meet. Temas a impartir. Editor de consultas de Power BI Extracción de datos: Extracción vs Direct Query Conectar datos alojados en diferentes orígenes Enlazar datos desde la consulta Entorno de trabajo para modelar con Power BI Introducción al modelado tabular con Power BI Tablas y relaciones Power BI – Modelos de datos Iniciación a DAX Fundamentos DAX 1. DAX en la práctica 2. Columnas calculadas y medidas 3. Tablas Calculadas ...

I'm seeking a skilled videographer to create an engaging fitness video about stress relief through a blend of intense pillow stomping and punching exercises. I envision the film to emphasize both actions equally with a high level of intensity to convey the exhilarating energy of this form of stress-busting workout. Ideal candidates should have prior experience in filming workout sessions and capturing high-intensity movements.

I am looking to have a professionally crafted Revit model accurately constructed from given Autodrawings. This project will play a crucial role in the construction documentation for my project. The desired outcome for this project will be a detailed Revit model (high level of detailing required) that will genuinely represent the constructional intent and detail of the original Autodrawing. Key Aspects: - The Revit model needs to embody all the construction details included in the provided Autodrawings. - The task requires the use of Revit 2021. - Prior knowledge and experience in Revit modeling for construction documentation are mandatory. If you are well-acquainted with the intricacies of Revit 2021, understand how to construct a high-detail model, and have prior experience in ...

I'm looking to elevate our existing WordPress website for my Native lead non-profit organization. Currently we have a Wordpress site I’ve designed with Elementor, however I am not a web designer and we’d like to bring it to a professional level. Our main goal is to build connections and promote dialogue with Native American tribal communities around Nuclear Energy and consent-based siting of spent fuel. Key functionality for the site includes: - Blogging: To share our upcoming events, updates, and highlight why this is important to Native Americans. - Information: We want to share info about consent-based siting, as well as nuclear energy, and our coalition that seeks to work for tribes. - Contact: A clear and easy way for visitors to find our information and re...

...understand for graduate students. - Target the graduate level: While the paper should provide a comprehensive understanding of the subject, it should avoid delving into unnecessary complexity. The ideal writer will be able to strike a balance between thoroughness and readability. - Engagement: The paper should be engaging and able to maintain the audience's interest throughout. This may include using case studies or examples to illustrate the concepts in a real-world context. The writer should ideally have: - A solid background in corporate finance: Experience or education in corporate finance is essential to ensure the paper is accurate and informative. - Previous experience in academic writing: Experience in writing for a graduate-level audience, and an understandi...

I'm in need of a professional who can assist with a PERT analysis for my project scheduling needs. - The focus of this job is on project scheduling - I would require the PERT analysis to be at a small task level; a detailed task breakdown is not necessary - You will need to integrate the PERT analysis with Microsoft Project This project would be most suitable for a freelancer with: - Proficiency in PERT analysis - Experience with project scheduling - Knowledge of Microsoft Project or similar tools

... - Track order status (received, processing, shipped, delivered). - Generate invoices and receipts for orders. 4. Shipping and Delivery Tracking - Record shipping details, including carrier, tracking number, and expected delivery date. - Update order status when shipped and delivered. 5. Reports and Analytics - Generate sales reports by date, product, or customer. - Inventory level reports. - Customer order history and patterns. Instructions: Based on the given information do the following: 1: Create a DFD using Visual Paradigm. (Note: we have worked on VP in class) 2. Choose Entities 3. Create ERD based on the entities chosen 4. Create tables/files for each entity 5. Enter minimum 3 records in each table. Read the Key Features to create Columns/Fields in the...

...facilitate the acquisition of an apartment complex in the next 3 months. **We will collaborate on the financial projections, specific business plan, etc. - we need someone who can beautify the hard data (text/financial projections/graphs/maps) and make it digestible to read for a prospective investor. Our end goal is to have TWO forms of this investment offering (a summary teaser that is high-level, and a more granular deck that contains additional detail) that we can recycle on future acquisitions by altering text & numbers without having to re-create the entire pitch** The offering must contain: - Detailed information on the property and a projection on the returns - A thorough market analysis and a disclosure of potential investment risk - A succinct summary of...

I'm in need of a schema markup expert with a high level of proficiency to implement necessary markup for my water treatment business - uswater. The project involves targeting approximately 60-70 cities for 5 different water treatment services. The website I'm working on is built on WordPress. Key Details: - I require schema markup for 5 different water treatment services, namely water filtration, water softening, water purification, legionella testing & management. - The focus is on 60-70 cities, although the range may widen based on the most cost-effective approach. Ideal Skills & Experience: - Proficiency in implementing schema markup, particularly for local SEO purposes. - Extensive experience with WordPress, as the website is built on this platform. - A deep ...

We are in search of an intermediate level Java developer with in-depth knowledge on multi-threading. The main task presents a for loop which needs to be partitioned between n number of threads. Your skills and experience should include: - Solid understanding of Java programming language - Hands-on experience with multi-threading in Java - Proven experience with running Java applications with multiple threads To ensure your competency for the task, applicants should provide documentation of past work specifically highlighting instances with similar programming challenges. Join us in this interesting endeavor, let's make the code more efficient together!

I'm looking for a proficient designer to elevate my simple and minimalistic logo to a new level of vibrancy. Task includes: • Adjusting logo colors: • Updating Icon:

I'm in need of a social media expert who can provide training across Facebook, Instagram and YouTube. Key Requirements: - Content Creation: The ideal candidate should be well-versed in creating engaging, high-quality content that resonates with our target audience on each platform. - Social Media Advertising: Knowledge and experience in developing and implementin...algorithms and best practices - Experience in creating and executing successful social media advertising campaigns - Proficiency in analyzing social media data and using it to inform strategy - Excellent communication and training delivery skills, with the ability to engage and educate a variety of team members. If you have the skills and experience to take our social media presence to the next level, I'd lo...

I am seeking a highly skilled Blender or Maya expert with proficiency in texturing. However, I am still uncertain and open f...Blender or Maya expert with proficiency in texturing. However, I am still uncertain and open for discussions on the modeling and the overall theme/style of the project. Requirements: - Expert in either Blender or Maya - Proficient in texturing - Ability to assist in creating 3D models if needed - Openness to discuss project's style and theme - Please include portfolio of previous work to show level of skill and style versatility. Any experience with various themes, particularly realistic, cartoon/animation, and abstract, is most welcomed. This project will be an open conversation and I am interested in your creative input. Let's create somethi...

I'm seeking a talented designer to materialize my vision for a unique, customizable emoji of myself in a PNG editable format. The scope of the project includes: - Facial Expression Customization: You should be able to render advanced facial expressions, capturing nuanced emotions such as smirking and pensiveness among others. - Platform: Though the primary deployment platform isn...proven track-record on similar projects or in creating personalized emojis will be highly beneficial. This project demands a keen eye for detail and a knack for understanding and channeling emotions into graphic design. If this intrigues you, place your bid and let's explore the uniqueness together. MUST HAVE BUBBLE ABOVE HEAD THAT CAN BE EDITED AS NEEDED. i'VE INCLUDED AN EXAMPLE OF AN EMOJI F...

I'm in need of a Freelancer Bench Sales Recruiter who will focus on the IT bench sales for my company. Sr. Bench Sales Recruiter - Freelance (Commission Basis) ...Types: Part-time, Freelance Ideal Skills and Experience: - Proven experience in IT Bench Sales recruitment is a must. - Strong network in the IT industry and access to potential candidates. - Proficiency in utilizing various sourcing techniques and tools to identify and engage with potential candidates. - Excellent communication and negotiation skills to ensure the successful onboarding of Senior-level candidates. - Experience in the freelancer recruitment model is a plus. This will be a freelance position and I'm open to discussing your compensation. Looking forward to working with a dedicated and results-or...

I am looking for an expert in RFID technology and .NET programming to integrate the RFID into our current weighbridge system. Key Details: - 3rd Party System was developed using .NET and it does support API or external interface connections. - The task will involve programming to fully integrate the system with RFID technology. Skills and Experience: - Proficiency in .NET programming & SQL Database - Previous experience with RFID technology - Knowledge of API integration - Experience with weighbridge systems would be a huge advantage. Your role will be to ensure the smooth functioning of the weighbridge system post-integration and provide us with a user-friendly, effective RFID solution.

I'm looking for a professional who can assist me in reaching the Partner level of Google's partnership program. Key Responsibilities - Assist in completing the tasks on My Status page to meet the Partner Level requirements. Ideal Skills and Experience - Proven experience in working with Google Partner Program - Strong understanding of accreditation requirements - Excellent communication and problem-solving skills - Ability to manage and prioritize multiple tasks

I am currently seeking a virtual assistant to help me with my job hunting in the technology sector. The role of the virtual assistant will primarily involve: - Job application submissions: The ideal candidate should be proficient in submitting job applications online, particularly for senior-level positions in the technology industry. This includes customizing cover letters to match job descriptions and ensuring that all required documents are submitted. Sharable resources: - resume - guide doc. Salary: $25 per week Responsibilities: - open job board platform accounts with my profile - apply for 200 proper jobs matching my profile every weekday - record them in the google sheet. Requirements: - fluent English is a must - prior experience working on similar stuff - software engin...

...Please bid only if you're willing to work with me live via zoom. *** I'm facing significant challenges with my WooCommerce website's performance. Here's what I'm experiencing: - Slow page loading - High server load - Database query delays Although I’m already employing caching plugins and techniques for performance optimization, the difficulties persist. My WooCommerce site is hosted on a VPS/Dedicated hosting package. I'm in need of a WooCommerce expert who has significant experience in performance optimization, handling high server loads, and reducing database query delays. The ideal candidate should have: - Proven experience in troubleshooting and improving WooCommerce site performance - Strong knowledge of server management, par...

I'm in need of basic architectural renderings for my online project consultancy. These will be used for client presentations specifically. Key Project Details: - **Type of Renderings**: Architectural - **Level of Detail**: Basic outlines and structures - **Intended Use**: Presentation to clients Ideal Freelancer: - Experience with architectural rendering - Skill in creating detailed yet simple visualizations - Understanding of client presentation needs in a digital setting I would appreciate if you could provide some relevant portfolio pieces with your bid.

I need someone who can help me ...Rearrange the current plain text documentation in Gitbook to improve its visual appeal and organization. - Apply intermediate customization to the layout - this includes adding custom fonts, colors, and navigation elements. Ideal Candidate: - Previous experience working with Gitbook or similar documentation platforms. - Proficiency in HTML/CSS as the customization required is at an intermediate level. - A keen eye for design and user experience to ensure the documentation is not just informative but also visually engaging. - Excellent attention to detail as the documentation must be accurately organized in Gitbook. This is a great opportunity for a freelancer with a flair for design to enhance and professionalize the layout of this documentation o...

I'm in need of an experienced English teacher to conduct intermediate level classes for adults. - The classes must be engaging and interactive, aiming to improve their English proficiency to an intermediate level. - Classes will be conducted in a group setting, so the teacher should be able to manage and cater to the needs of multiple students. - It's crucial that the teacher can provide comprehensive lessons that cover all aspects of English - reading, writing, listening, and speaking. - The ideal candidate should have experience in teaching adults, and be able to tailor content and activities for this age group. - Proven experience in teaching English as a second language is a plus. Your role will be to help students gain confidence and proficiency in English...

I'm seeking the expertise of a Laravel developer who's at least a beginner but possesses a solid understanding of user authentication, database integration, and payment gateway integration. The primary goal of this project is to build a web application. Skills and Experience Needed: - Beginner to intermediate level experience in Laravel development - Proficient in user authentication methods - Understanding of database integration within web applications - Familiarity with integrating payment gateways This project offers an opportunity to apply and further develop these essential web development skills. Your input will be absolutely crucial in taking this web application from concept to a tangible, fully functioning technology.

I'm looking for an intermediate-level Node.js developer who can help me in building a server-side API and real-time applications. Key Responsibilities: - Develop server-side API: You will be responsible for creating a robust server-side API that can handle data requests efficiently. - Build real-time applications: You should have experience in developing real-time applications that provide seamless user experience. Ideal Skills and Experience: - Hands-on experience with Node.js and server-side development. - Familiarity with real-time application development. - Proficiency in using frameworks like , , and will be a plus. - Prior experience in building scalable and performant applications. - Intermediate level of experience and expertise in Node.js development.

I am in need of an experienced expert to design a dehumidification system for my entire household. Energy efficiency, noise level, and capacity are critical factors for this design. Essential Skills and Experience: - Experience in Environmental Systems Design, specifically for dehumidification or similar indoor regulation systems - Familiarity with designing complex residential systems - Strong emphasis on energy-efficient design strategies - Understanding of noise level control within system design - Experience with different dehumidification system capacities Potential applicants are kindly asked to highlight their experience and give relevant examples of previous work.

• Experience with Testing tools Experienced using SQL Advanced experience developing test metrics and reports Experience with Automated Testing Five (5) • years of Testing experience in a Software Development Lifecycle environment Five (5) • SQL and PLSQL Programming in SQL Server ETL and Data warehouse process Informatica 10 • 20 Informatica Data Quality Profiles , Score Cards SQL Server RDBMS SQL Server Analytics Services SSAS SQL Server Reporting Services SSRS Tableau Reporting BMC Control M Scheduler Tool Data Analysis Data Profiling Application Life Cycle Management Complete Testing process SDLC, Agile Process, SAFE and Kanban methodologies, TFS Tool Good Communication Skills and Quick Learner Selenium Automation Unix Finan...

I'm looking for a skilled teacher who can educate students on intermediate-level IT concepts. The ideal candidate will have a strong understanding of BTEC curriculum and previous experience teaching at this level. Key requirements: - Proficiency in IT: Knowledge of networking, programming, cybersecurity, and other IT fundamentals. - Previous teaching experience: Experience in teaching intermediate-level students is preferred. - Familiarity with BTEC: A strong understanding of the BTEC curriculum and its requirements. - Excellent communication skills: Ability to convey complex information in an understandable and engaging manner. - Report-based delivery: The teaching sessions will be delivered through reports, so the teacher should be comfortable with this mode o...

I'm seeking an IT teacher to create a unit set assignment for an intermediate level ICT course. The ideal candidate should have adept ICT knowledge and experience. Key Requirements: - Vast knowledge in ICT. - Should have experience in teaching IT related subjects. - Adept at creating quality educational content. - Excellent English writing skills. - Preferably worked with BTEC (an added advantage). The task is to create a unit set assignment that should be well-structured and comprehensive for an intermediate level ICT course. The assignment must be delivered in a Word document format. Ideal Skills: - Proficient in ICT - Excellent English writing - Experience in creating educational content - Previous experience working with BTEC (advantageous)

Using Bambu AMS printer and am looking to have a football field built. I need a field with 2 goal posts and the lines. In bambu slicer i can color blocks so goal is to click lines white then each grass segment and end zones varyong shades of green. File will be printed then placed inside stadium as a fini...grass segment and end zones varyong shades of green. File will be printed then placed inside stadium as a finished product Just like attached photo but with the yard lines drawn so they can be "painted" in bambu studio. More details: Football field. Not the stadium just the field. What dimensions do you want for the football field model? Standard dimensions (120 yards x 53.3 yards) What level of detail do you require for the field, such as textures and ...

I am a motivational speaker, and my objective is to create compelling video ads that effectively target professionals, entrepreneurs, and C-level executives. The main focus of these ads will be: - High-quality, engaging video content - Captivating messages that resonate with my target demographic - Strategies designed to generate more leads The ideal freelancer for this project should have: - Expertise in video ad creation and editing - Proven record in creating successful video ads - Excellent understanding of target market dynamics - Skills in lead generation Your innovative ideas will be invaluable in achieving my goal of expanding my influence and reach in the professional and entrepreneurial spheres.

I'm looking for someone to create advanced level anatomy questions in multiple-choice format. These questions are intended for test preparation for the USMLE. Ideal candidate for this project should have: - Proficiency in anatomical knowledge and terminology. - Experience in creating test questions. - Proven track record in preparing advanced level quizzes or study materials. - Attention to detail, accuracy and the ability to create questions with varying levels of difficulty. Please note that the questions should be both challenging and relevant to test preparation.

...the last row of data was successfully extracted. Scraper Functions Function: list_category_tree Input: competitor_name(astro | sayurbox | segari), existing_csv (optional - CSV file to append to for continuing execution, if the scraper stopped or got IP blocked) Output: CSV of category tree with the following columns (scrape_date, URL, category name, position index, parent_category (null if top level)) Function: extract_sku Input: competitor_name, location (autocomplete place from google maps API), category (optional - extract SKUs from all categories if null), sub_category (optional - extract all SKUs from all subcategories if null), existing_csv (optional - CSV file to append to for continuing execution, if the scraper stopped or got IP blocked) Output: CSV of SKUs with th...