Can write query years service sqlงาน

...understand our services, and consume our content with ease. Creating a Web and App-based Referral System: - I am also interested in having a referral system being designed. This includes both a web-page and a mobile application compatible with iOS and Android. - A user-friendly interface, simple design but with security, tracking, and monitoring capabilities is a must. Ideal Skills: - More than five years of experience in website redesigning, and application development. - Must have a sound understanding of Referral System Development. - Proficiency in iOS and Android app development - Proven experience in improving text organization on a user interface. - Positive customer reviews and case studies showing successful similar projects. By taking on this project, you'll co...

I invested few lakhs to acquire a 1.02% stake in an SPV. Despite the overall sale price appreciation over five years, I'm facing a loss upon exit, contrary to expected gains. I'm seeking a forensic audit service to conduct a thorough analysis of this matter. I will provide my observations along with the Audit report and Bank statements. Before bidding, please ensure you have experience in conducting forensic audit investigations and the ability to observe irregularities (which will enable me to engage in a more informed dialogue with the SPV team). Key responsibilities: - Focus is primarily on the review of financial statements - Identify any signs of financial fraud - Deliver a comprehensive report of your findings Ideal candidates for this project should have: ...

...and a construction of a garden guest room. 20sqm. The project is ready to start, just need supervisor to oversee the contractor in order to prevent possible mistakes. Engineers duty includes fully supervision to the completion of the project, managing workers, ensuring quality control of the construction, and meeting the timeline. Ideal candidates will be graduated civil engineer with min 10 years supervising and managing constructions from A ro Z experiences. Must haves: - Prior experience in project management particularly in residential construction. - Strong understanding of construction process, regulations and safety. - Ability to anticipate potential problems and solution-oriented mindset. I look forward to receiving your bids and discussing this further with interest...

I'm looking for a professional who can help me get a blue tick verification for my daily active Facebook page. - I need this verification to enhance the credibility of my brand. - The ideal candidate should have prior experience in obtaining blue tick verification for Facebook pages. - They should also be familiar with the requirements set by Facebook to ensure a successful verification process. Please provide examples of previous verifications you've successfully secured, and share your approach to this project.

I need an adept SQL developer proficient in crafting SQL queries for various tables within our database. The task entails generating four queries, each encompassing approximately 20 conditions that must be met. Utilizing ChatGPT, could you assist in devising these queries?

Seeking to replicate the website attached in "Home page data" using AI to enhance SEO for better rankings. Color scheme: primary color grey, secondary color red. Data for our website Home page: Service page (with 2 separate product pages as in data attached): Modded accounts page (with 2 separate product pages as in data attached):

โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด

I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized project: The data needing in...

With over 9 of years experience dealing with presentations. I can help design your Presentations/Deck professionally with engaging visuals and graphics.

I am looking for a skilled person to create a professional company portfolio for our home automation touch switch board manufacturing company. The file should include the following features: - An About Us section which covers: - Our company history - Mission and vision - Our strengths - Service offerings - A Services section that highlights our key service: - Home automation touch switches The ideal freelancer for this project should be experienced in creating a sleek and functional portfolio. Knowledge of design principles and an understanding of the electronics or home automation industry would be a plus. Previous experience in developing a portfolio for manufacturing or technology companies will also be highly valued. Please share your portfolio of similar pr...

I am seeking a proficient resume writer experienced in creating professional, eye-catching resumes, specifically targeted towards a regulatory role. I have over a decade's worth of relevant experience for the prospective role(s) I will be applying for. Following are the specifics: - Drafting a Word document - Accentuating my experience of over 10 years in customer relations and regulatory roles - Presenting a compelling case for my candidacy for an environmental compliance officer role. The ideal professional for this task would be someone with proven experience crafting professional managerial resumes, with a keen eye for detail and impressive design skills. Excellent command over language and significant understanding of the corporate managerial world would put you at the...

Hello everyone. I need a query for prestashop version 1.7.8.10. I need to run 2 times a day a check script on products that have quantity 0. When I have quantity 0, I need to disable the product. I need a script that performs this operation 2 times a day.

Hi Global Service 24/7, I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I'm looking for a professional email marketing agency that can manage an email campaign for me. Essential skills/experience required: - Proficiency with email service like mailchimp or similar - Previous experience in email marketing, particularly in promoting products - Ability to send follow-up email Key deliverables: - Sending out 350 emails using our email id - Creating and sending follow-up emails - Providing a detailed report on the campaign's performance Please note, I have a template for the emails already. I also have the database of the people to send out in excel format - company name, email, first name and last name - so it should be easy

Note: Budget Fix 2000INR and time line 5 Day's I have a project currently in Codeigniter 3, and I'd like it converted to Laravel 10. This process will require thorough understanding of both frameworks, and it's crucial that all existing features...functionalities are precisely replicated in the new version. While I don't have specific features to prioritize, I will identify specific elements as the project progresses. Skills and experience required: - Profound knowledge in Codeigniter 3 and Laravel 10 - Expertise in PHP development and SQL databases - Proven experience in similar conversion projects Note: The finalized budget for this project is 2000INR. Please only bid if you can work within this budget. The timeline for project completion can ...

15% commission bonus + flat rate I am looking for experienced cold callers who can effectively set appointments for my web development business. Your main task will be to reach out to potential clients, presenting them with our unique selling propositions. Responsibilities will include: - Appointment setting. Your main goal is to turn potential clients into confirmed appointments. - Developing your own pitch. While I want you to understand my business thoroughly, I do encourage creativity. I believe a personal approach works better in cold calling so feel free to develop your own effective pitch. - Emphasizing our strong points. Our web development service stands out for its competitive pricing and proactive customer support. Your pitch should revolve around these selli...

I am looking for Website for B2B and B2C. Data will be reflect to the Admin portal from both B2B and B2C pages. Need to create 5 pages for Website B2B Page Tasks Need to create Query request form on B2B Need to create registration form on B2B Need to create Inventory management page on B2B B2C Pages Need to create registration page using whatsapp, social media and phone Customer can search for the desired result which will be based on the B2B inventory management page In the result page our recommendation will be listed at the top Need to create app for B2B and B2C for android/IOS

Hi Suman Y., This is Ashish Harit and I got my work done through few years back. I need to get a dentist board signage to be designed.

I am in need of a skilled freelancer with expansive knowledge in tax filing and planning, financial statement preparation, audit and assurance services, winding company procedures, and addressing private limited pending compliances. Ideally, you should have vast experience in handling financial matters for small businesses. Your application should include: - Detailed project proposal: Kindly break down how you plan to provide the services I require. Highlight your approach, the steps you will take, and the tools and methodologies you will employ to ensure everything is done professionally and up to standard. Skills and Experience: - Certified Accountants and Company Secretaries: Given the complexity of the work, it's crucial that you have completed professional certifications. T...

I need a comprehensive business plan specifically for a children's tableware business targeting preschoolers (3-5 years). The main goal of this business plan is to guide my business operations strategically. Key aspects that should be incorporated in the plan include: - Comprehensive Market Research: Specifically tailored to the local community markets as these are the primary target markets. - Competitive Analysis: A detailed evaluation of the current and potential competition within the preschooler's tableware industry in local community markets. - Marketing Strategy: Developing an effective and robust marketing strategy that appeals to this particular demographic. - Financial Projections: Accurate and detailed financial projections to chart the path for sustainable g...

As an ambitious professional seeking freelance opportunities, I bring a unique blend of skills in content writing and website development. Key capabilities include: - A wealth of experience in crafting compelling written content, honed over years of successfully delivering diverse writing projects. - A robust understanding of website development, that enables me to create or enhance digital platforms in alignment with client vision and needs. My combined proficiency in these areas makes me an ideal candidate for projects that require both high-quality content and web development expertise. Get in touch if you have need of such dynamic project execution.

...Gathering on Digital Keys Using Smartphones <Request Details> Please gather product information on cars equipped with the technology described in the “2. Technology to be Searched” section below. *Note Do not gather information based solely on the information listed in the “1. Background” and “3. Reference Information” sections (Sections 1 and 3 are for reference only) [1. Background] In recent years, there is a technology that uses digital keys registered on smartphones to perform operations such as locking and unlocking vehicles, and starting the engine. However, if the user operates the vehicle settings to disable the digital key function, there is a problem that users who only have a smartphone cannot control the vehicle. [2. Techn...

I'm seeking a freelancer with data entry and copywriting skills to work on a project that generates income through freelance writing. Key Tasks: - Data Entry: involves inputting, updating, or verifying data in a system or database. - Copywriting: creating persuasive and engaging written content to promote or sell a product, service, or idea. The ideal candidate should have: - Proven experience in data entry and copywriting - Strong attention to detail and accuracy for data entry tasks - Excellent writing and editing skills, with a focus on copywriting - Understanding of SEO principles for copywriting is a plus This project is perfect for someone with a passion for writing and the ability to generate income through their work.

...for reference only) 【1. Background】 This technology pertains to a system for updating the programs of devices installed in vehicles. Many devices are installed in vehicles, and these devices store programs. It has been proposed that by updating these programs, the functionality of the devices can be improved. In particular, it has been proposed that by receiving data for program updates from an external server via wireless communication, it is possible to update the program without going to a service station or the like. In previous technologies, a specific device functioned as a master device and updated the programs of other slave devices. However, this had a problem. That is, the master device had to perform processing dependent on a specific device configuration of the...

...technology described in the “2. Desired Technology” section below. *Note Do not collect information based solely on the information listed in the “1. Background” and “3. Reference Information” sections (Sections 1 and 3 are for reference only) 【1. Background】 This is a technology related to charging the on-board storage device with power supplied from an external vehicle charging facility. In recent years, the development of electric vehicles capable of “plug-in charging” using a charging cable for power supply has been progressing, and there is a problem of heat loss at the charging facility, charging cable, and vehicle charging inlet. Therefore, technology is required to protect these from excessive temperature rise. On the other...

...we require tailored plan - not a generic list of website improvements. this is for a Woocommerce website that already has WP Rocket installed, WebP images optimised etc. Basically all the easy optimisation has been done. But still a very slow site., Need someone who can spend a bit of time analysing the site and advising the next steps in order of most beneficial. We have in-house developers who may be able to complete the suggested changes, or we may discuss costs to get you to do the requested changes. This initial service request is simply asking for a tailored action plan of what needs to be done to improve speed & Page Speed insights score. Note we are not looking to move hosting provider, and ideally don't want to use a CDN (unless your action plan ident...

I'm seeking a skilled and creative social media marketer and manager to spearhead a multi-month the promotion of my upcoming children's book for kids 5-8 years of age to be published mid September, 2024 on Amazon. You'll be working alongside my illustrator to curate and manage content for various social media platforms with a focus on Facebook, Instagram, Twitter, YouTube, TikTok, and Pinterest. Key Responsibilities: - Collaborate with my illustrator to create engaging and visually appealing content - Develop a social media strategy tailored to each platform - Manage day-to-day social media operations - Implement a pre-order campaign in August to boost visibility and anticipation for the book in mid-September - Create and manage ad campaigns across multiple platforms...

I'm seeking a talented professional to design a comprehensive business case for my technological solution in child protection. This document will primarily be used for presenting our business to potential investors and stakeholders. Most of the content has already been compiled and available...skills and experience for the job include: - Business case design experience - In-depth knowledge of business case requirements and necessary inclusions - Shrewd understanding of investor and stakeholder expectations - Previous work on startup projects is a bonus - Communication Your task will involve developing an investment-ready business case that effectively communicates our business model, service offerings, and social impact benefits with an aim to secure necessary funding and stak...

I am looking for a skilled Wordpress developer to assist me with my website. The project involves some custom work, particularly in the area of order tracking and user a...that allows users to track the status of their orders. This feature should also enable manual entry of order updates by admin. - Downloadable Reports: Once a project is completed, users should be able to download a report related to the service they ordered. The ideal freelancer for this project should have: - Proficiency in Wordpress development - Experience with custom dashboard creation - Strong understanding of user account management and order tracking systems - Excellent communication and problem-solving skills. If you have relevant experience and can deliver a high-quality, functional website, ple...

...individual who can write 20 Papers - each Paper at least 5 pages describing the critical tasks and AI Solutions on monitoring tools and Data Analytics. Each paper should consist of all the categories as attached sample along with diagrams and References. Attaching one Sample Paper for Reference. Key Responsibilities: - These Papers should be 100% plagiarism free and should not be detected under any AI Detectors - Should be able to Write Papers 20 Papers Total - 5 pages in each Paper - Explain the task in detail along with diagrams (Attaching the Sample) I'm looking for someone with: - Proficient English skills for clear communication. - Experience in data analysis, and the APM, Customer Experience tools. - Strong problem-solving skills and attention to deta...

This role requires you to perform various duties including, social media marketing, customer service, and call center operations. Duties and Responsibilities: -Organize and maintain all information - Handle and coordinate all records -Handle social media platforms to market the company and its products -Manage customer inquiries and complaints -Assist with team and client communication -Perform call center operations and handle customer calls -Handle online and offline customer inquiries - Provide excellent customer service Basically, we are a realty firm and we managed some vacant residential properties which are available for rents and your tasks are to list these properties on the rental websites as , , and some other rental websites which will be

UI/UX Figma + + TailwindCSS Development We are looking for a qualified developer with 5+ years of experience, specializing in UI/UX building and proficient in Figma, , TailwindCSS and Typescript. Our goal is to design and redesign an e-commerce website focused on trading. We already have an existing foundation, but it needs to be refactored to improve code organization and user experience, as well as improve visuals. Main Requirements: - Experience in dealing with the PT-BR language (Brazilian Portuguese) - UI/UX with Figma: Ability to create attractive and functional designs. - and TailwindCSS: Proficiency in front-end development using these technologies. - Typescript/Javascript: Strong knowledge in programming. - Code Architecture: Solid understanding to maintain

The primary objective of this project is to construct a potent sales funnel that can effectively surge the volume of leads for my consulting services, specifically tailored to the needs of large corporations. The project will require: - Solid understanding and experience in building successful sales funnels - Proficiency in producing innovative strategies specifically for large corporations - Background knowledge in the consulting services industry - Ability to analyze the market and adjust strategies accordingly for optimal lead generation. A candidate with a strong track record in achieving results in similar projects will be highly valued.

I'm on the hunt for a creative, strategic, and professional commercial ad creator/operator. We are focusing on promoting a particular service targeted adventure or trilling experience seakers. Wishing to establish a high-impact commercial ad featuring a movie trailer-like vibe. Key points: - Your mission is to make the product/service genuinely stand out amongst competitors. - Captivate the attention of career professionals through an engaging, suspense-filled trailer-like approach. - Keep the advertisement professional and sleek but unique enough to leave a long-lasting impression. Ideal candidate's skills: - Stellar storytelling capability - Experience in creating high-impact movie trailer-like commercials - Deep understanding and insight of the chosen demograp...

As a commercial property owner, I am in need of a thorough review of an office space lease agreement. The lease will span for a long duration; more than 3 years. Key Requirements: - Experience with commercial property lease agreements. - In-depth understanding of real estate laws and regulations. - Ability to give clear insight and recommendations on stipulated contract terms. - Can work swiftly and accurately, with attention to detail. With the right expertise, there’s potential for a long-term professional relationship on my real estate ventures.

I need quotes for a small-medium residential project and a service-based commercial project. For the residential project: - The project is small in size and moderately complex - I'm looking for a reliable estimation of the costs involved - Experience with residential projects is highly desirable - Bare lot sub divisions, sub developments, single home builds, concrete quotation, drainage, earthworks quotation. For the commercial project: - This is a service-based business, not retail or restaurant - I'm interested in understanding the general cost of construction - Experience with commercial projects in a service-based setting is an advantage

...seeking an experienced Business Analyst or Operations Consultant to help enhance the efficiency and productivity of our customer service operations. The main goal of this project is to revamp our current processes and practices, and to implement structures that will in turn improve customer satisfaction. Key responsibilities and expectations include: - Analyzing current customer service operations: You'll need to evaluate the existing workflow, resources, and tools while identifying process bottlenecks and inefficiencies. - Proposing and implementing improvements: Using your expertise, you'll develop strategies and solutions that will make our customer service more efficient, effective, and responsive. - Tailored recommendations: These should be specific...

I have been doing online business for more than five years. The 2023 revenue is $4.5 millions. I'm on the hunt for a professional high ticket sales closer with an in-depth understanding of the e-commerce industry. I'm launching an online school focusing on teaching individuals how to build successful multi-million-dollar e-commerce businesses. My target audience is motivated individuals eager to learn the e-commerce ropes and willing to invest in high-level education. Key Responsibilities: - Convert interested prospects into students - Possess persuasive consulting services skills - Foster relationships with potential clients Ideal Skills and Experience: - In-depth knowledge of the e-commerce industry - Proven track record in high ticket sales - Expertise in consult...

...high-complexity T-SQL stored procedure used for data analysis that I need translated into PySpark code. The procedure involves advanced SQL operations, temporary tables, and dynamic SQL. It currently handles over 10GB of data. - Skills Required: - Strong understanding and experience in PySpark and T-SQL languages - Proficiency in transforming high complexity SQL scripts to PySpark - Experience with large volume data processing - Job Scope: - Understand the functionality of the existing T-SQL stored procedure - Rewrite the procedure to return the same results using PySpark - Test the new script with the provided data set The successful freelancer will assure that the new PySpark script can handle a large volume of data and ...

I am looking for someone to help expand my company that provides services. Our target audience is both businesses and individuals. Key Responsibilities: - Research and identify market opportunities - Develop strategies to grow the business - Execute marketing and sales plans - Enhance online presence and engagement The ideal candidate should have experience in the service industry and demonstrate a strong business acumen. Experience in developing online platforms and digital marketing would be a plus.

I'm looking for a funnel specialist who is an expert in creating high ticket funnels for service based businesses. My main goal is to increase sales for our service-based business through the funnel. Key Requirements: - Proficiency in ClickFunnels, GHL (GoHighLevel), or any other Major Funnel System - Previous success in building funnels that have significantly increased sales - Understanding of high ticket service-based business models Your responsibilities include: - Building a complete sales funnel from scratch - Ensuring the funnel is user-friendly and optimized for conversions - Implementing necessary tracking and analytics tools

...invoices. The GPT should be capable of answering questions related to these invoices. For example: "Sum all subtotals of invoices in folder April2024invoices." Integration with Excel: From within Excel, I want to be able to call the custom GPT "GPT-Invoices" by writing a query in a cell. For example, in cell A1, I should be able to write: =GPT-Invoices("sum all Subtotal values of invoices of April 2024"). The output answer should be returned in the same cell (A1). Deliverables: A fully functional GPT-Invoices model that can analyze invoices from OneDrive folders and answer queries as described. A VBA (or other appropriate method) integration in Excel that allows calling the GPT-Invoices model and returning the response in the same ce...

...It allows users to access multiple government platforms and services with a single set of credentials. When a user attempts to log in to a participating website or application, they are redirected to a common login page hosted at "". Here, users can enter their credentials, typically consisting of a username (usually their CPF - Cadastro de Pessoas Físicas, the Brazilian individual taxpayer registry identification) and a password. Description: I am reaching out to inquire about a service you may provide regarding the automation of login within a Docker environment. I have encountered difficulties automating the login process on , particularly when attempting to execute the script within a Docker container. Despite successful tests on my local develop...

We need to improve an already existing pitch deck. Our project is to bring UFCGYM to France. The goal is to convince investors to put money on the table with the pitc...with milestones on market number and our financial analysis Ensure clarity and simplicity by using clear and simple charts to present financial data, avoiding information overload on a single slide. Utilize data visualizations like bar charts, line graphs, pie charts, and infographics (you can redesign the charts already put in the model). Incorporate interactive visuals for digital presentations if possible. Highlight key figures with distinct colors and larger font sizes. Present trends over multiple years to show growth or changes in metrics. If you need additional figures ask us. We would need this to be f...

I'm in need of a cutting edge informational website for my business. The primary objective of this website is to encourage visitor interactions and prompt them to reach out to me. the company has been here since 1997 but we are now under new manag...Us: This section should provide a clear background of my business, including its history, mission, and values. as well as a section that allows them to contact us through email The ideal candidate for this project should have experience in: - Developing interactive and appealing informational websites. - Incorporating effective call-to-action elements. - Designing and integrating testimonial, service highlight, and about us sections. A keen eye for detail, creativity, and understanding of user experience principles would be high...

I require an informative, easy-to-navigate website for my removal service business. The site should promptly present our services and provide detailed information about our company and team. Key features required: - User-friendly interface - Company Colors are Navy Blue, Burnt Orange, White, Black, and Grey. We would love to stick to that color theme. - Logo should be displayed on top of ALL pages, along with business phone, address, and business hours. - Business Phone, address, and business hours should be displayed on a burnt orange color border in white color font. - On the HOME PAGE we must have a button for "CALL FOR APPOINTMENT" and "REQUEST A QUOTE" - On the " REQUEST A QUOTE " page...the fill-out form should have the customer's FI...

I am searching for an experienced financial specialist to assist me in securing capital funds exceeding $500,000 for my service industry business. The capital will primarily be utilized to support and expand business operations. Ideal Candidate Skills: - Extensive experience in fundraising and capital generation in service industries - Proven track record of successful capital raising ventures - Deep understanding of service industry requirements and constraints - Strong business acumen and strategic planning skills Responsibilities and Goals: - Develop innovative and effective capital raising strategies - Assist in identifying potential investors and negotiating terms - Provide advice on efficient allocation of capital for business operations - Facilitate the real...

...Account creation and login via email or Google account, admin panel for managing user accounts. - **User Profile:** Profile completion with name, photo, description, and payment information. - **Geolocation and Filters:** Find nearby services using geolocation, filter services by category, distance, etc. - **Service Posting:** Service providers can publish services with details, photos, and prices, users can view service details. - **Messaging:** Integrated messaging system for users and service providers. - **Payment System:** Secure payments for services, admin management of transactions and commissions. - **Admin Panel and Statistics:** Dashboard for managing users, services, and transactions, view usage statistics and reports. - **Testing an...

Dear Freelancer Ple...We are looking for an specialist (freelancer, not a service provider) to help us with the implementation of the ABP framework - Installation is done on our server (dedicated infrastructure for the project, no local installation on your computer) - The person must be able to give us advice on strategic choices - A POC will be requested depending on our needs Important: a) If you don't have time or interest in the project b) If you're looking to change our initial goals c) If you do not wish to be integrated into a group structure or work in the interests of a group of developers d) If you are not working in transparent mode Please don't waste our (your) time The average commitment of our employees is one year to three years Thank you...