Sql queries for dummies punët

Hi Do you have experience with both mulesoft and salesforce? It iş sql and salesforce integration using mulesoft For now my task is to solve this error so let see how many hours it takes us and for the new project we will discuss the time per week I need indian time tomorrow morning 7:30 am This support will be on zoom meeting which we will provide u and u will connect with my consultant for support

I'm seeking a proficient developer to create an innovative web-based chat application using Natural Language Processing (NLP) and AI. This app should be able to analyze uploaded CVs and automatically respond to predefined queries such as years of experience and areas of expertise. Key Requirements: - The application should implement NLTK and Tensorflow as primary AI and NLP technologies. - The solution should not be a copy; it requires originality and a functional outcome. - Importantly, it should feature user authentication and login functionality. Ideal Skills: - Proficiency in NLP and AI, with strong knowledge of NLTK and Tensorflow. - Strong experience in web-application development. - Capabilities in implementing secure login functionalities. - Proven ability to develop...

...unified communications hub. The goal is to reduce manual tasks and enhance customer engagement. Key Deliverables: Platform Selection and Setup: Assess suitable automation platforms to determine the best fit for my business needs. Configure the chosen system to manage all social media accounts and integrate fully with WhatsApp Business. Workflow Development: Create automated workflows to handle a variety of tasks, such as: Social media post scheduling across multiple platforms. Automatic responses, lead capture, and customer queries on WhatsApp Business. Cross-platform data synchronization for consistent messaging. Customization and Flexibility: Tailor the platform to my specific branding and communication style. Ensure the system is adaptable to future business ...

I am actively seeking an API development expert, specifically for SSO and SAML integration. Let's dive into what I am specifically envisioning for this project: - Proficiency: I will need someone who is familiar with SSO, SAML, React, Node.js and SQL. Your past experience in similar projects will be highly valuable. - Functionality: A primary objective for this task is to develop an API that has Single Sign-On (SSO) and Security Assertion Markup Language (SAML) functionality. - Purpose: The purpose of the API development is to integrate SSO and SAML for user authentication in my system. Maintaining security, ease of use, and adaptability is crucial. In conclusion, your task primarily revolves around strengthening authentication methods via respec...

We are a Premier Online Coaching Platform, evidence-driven, thriving to build an unbreakable mindset. This is also India's first website that calculates the exact number of calories with detailed macro nutrient distribution for a particular person based on their bio feedback. The website is absolute new, and nothing has been done yet apart from creating the entire thing as of now. There are a few tweaks and updates along with SEO that I need on the website to make it more human, interactive, responsive, fast & user friendly both in terms of desktop and mobile. These are the detailed requirements as of now: 1. Forms, Thank You pages upon submitting forms, making purchases and email responses. 2. Replace contact button from the home page and menu with a simple white band

I have a small FileMaker Pro 12 database that requires a conversion to an SQL-based database. The structure is to largely remain the same, but there are some minor issues that need rectification. Details: - The conversion task requires no major changes to the original data structure. - However, some calculation errors need fixing. Therefore, you'll need a keen eye for identifying and rectifying them. Skills & Experience Required: - Experience with FileMaker Pro 12 and SQL databases. - Understanding of database structures and functionalities. - Ability to identify and correct calculation errors. - Great attention to detail. Please ensure that during the conversion process, no data is lost, and the end product works seamlessly. The bid proposal should ref...

...tempo. Aplicar técnicas de aprendizado de máquina para ajustar as recomendações de tratamento. Tecnologias a Serem Utilizadas: Frontend: HTML, CSS, JavaScript para criar uma interface de usuário responsiva. Backend: Node.js ou Python para lidar com lógica de negócios e integração de IA. IA: Frameworks como TensorFlow ou PyTorch para modelos de aprendizado de máquina. Banco de Dados: MongoDB ou SQL para armazenar dados de usuários e interações. Considerações Éticas: Garantir a confidencialidade e a segurança dos dados dos usuários. Estabelecer limites claros para a intervenção da IA e a necessidade de encaminhamento para profissionais humano...

I am in need of an experienced professional to craft terms and conditions for my business. The project entails creating three separate documents, with the combined length expected to be around 24 pages - I'll provide samples. Key skill is basically strong ability with Microsoft word Key aspects of the project include: - Crafting legal language: I require someone who is well-versed in legal terminology and can create precise, legally-binding content. - Document structure: The terms and conditions should be logically structured and easy to navigate. - Originality: The documents should be custom-made for my business, not copied from existing templates. While I did not address specific policies or documents in the initial questions, the ideal candidate will be able to guid...

...brand logo for my publishing house utilizing a particular color and theme. Your creative expertise will help bring my branding vision to life. Key Project Elements: - Color Scheme: The primary color for the logo should be light blue and violet something like the picture. - Logo Style: The style of the logo should be representational. - Design Elements: The design should creatively incorporate a book and a butterfly motif. Ideal Skills and Experience: - Proficient in Adobe Illustrator or similar software - Strong portfolio of previous logo designs - Experience in branding and corporate identity - Outstanding creativity and innovativeness Delighted to receive your bids, together with work samples showing your aptitude in logo design. Don't hesitate to ask if you h...

...previous versions when needed. SEO Optimization Features: - SEO-Friendly URLs: The system should support custom URLs that are easy to read, relevant to the page content, and optimized for search engines. - Meta Tags Customization: The CMS should allow clients to customize meta tags, including title tags, meta descriptions, and keywords for each page. - XML Sitemap Generation: The CMS should automatically generate and update an XML sitemap, making it easier for search engines to crawl and index the site. Security Features: - Vulnerability Protection: Ensure the CMS is robust against common web vulnerabilities like SQL injection and XSS attacks. Skills and Experience: - Strong PHP and CMS development background. - Proficiency in implementing SEO best practi...

...automated as much as possible. - It should have the capability to save both sent and received - The add-in should be efficient, ensuring that no emails are missed in the process - A simple yet effective interface that is easy to navigate and use is crucial The add in will: - query a SQL database and find clients linked to the sender/recipient and prompt the user to select the relevant client - Save a copy of that email to the relevant folder for the selected client - again based on a SQL query. The SQL query information can be provided to facilitate this. Ideal Skills and Experience: - Proven experience in developing Outlook add-ins. - Knowledge of Microsoft Outlook's functionality. - Strong attention to detail to ensure proper email categ...

I'm facing a challenging issue where my ASP.net application can't connect to a MySQL database. I need a fast solving of this problem and want to start in the next hour !! Here are the issu...is MySQL - using AWS mySQL RDS - Asp.net server is on Amazon EC2 - There's no connection to the database at all message: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond Check image below with error message. It is an older database, maybe we need update some libary for connecting or whatever. I prefer to connect with anydesk or other remote desktop software. Before write me you basic steps how you try to solve the problem or write that you know ...

I'...perform detailed data analysis. Key Responsibilities include: - Designing and creating visually stimulating Power BI dashboards that succinctly translate complex data into understandable and actionable information - Generating impressive data visualizations - Conducting thorough data analysis The data for this project will be sourced mainly from Excel spreadsheets and SQL databases. Ideally, you should be proficient in handling and interpreting data from these sources. Data refreshes are planned for a weekly interval. Experience with such a schedule and understanding how it impacts and influences dashboard functionality and data visualization will be beneficial. Only those with proven track record in Power BI dashboard development, data visualization, an...

...showcasing our range of export goods. This is vital to enable our B2B clients to browse and select products efficiently. - Shopping Cart: A shopping cart feature is essential to facilitate seamless transactions for our clients. It should allow for easy addition, removal, and payment processing. - Live Chat Support: The website should include a live chat support system to provide real-time assistance to our customers. This feature will be crucial for addressing any queries or concerns promptly and ensuring a positive user experience. Target Audience: - The primary target audience for the website is B2B clients. As such, the site should be designed with the specific needs and preferences of businesses in mind. Experience in B2B website development would...

Looking for freelancer with previous loan website design experience, to develop WordPress website for our loan agency. Our main goal is to sell loan services like home loan and mortgage loans to potential customers. We require the following specific features on our website: - Online loan application: Users should be able to easily apply for loans directly on our website. - Live chat support: We need a live chat feature to provide immediate assistance and answer any queries that users may have. - Loan calculator: The website should include a loan calculator tool to help users estimate loan amounts and repayment terms. - Google speed insights speed should show 95+ - All Seo parameters to be followed. The ideal candidate for this job should have experience...

I am currently looking for an MS SQL trainer to help with physical training in chennai. - Expertise: While the selected trainer needs to have intermediate level skills in MS SQL, having advanced skills could be a bonus. However, the ability to explain complicated topics in a simplified manner is paramount. - Topics: Though a choice was not specifically provided, your comfort with a range of MS SQL subjects will be beneficial. From database administration, querying data to data integration, any and all skills are welcome. - Time frame: This is an immediate requirement. Hence, applicants who are available to start at the earliest will be preferred. Ideal candidates should have considerable experience in training others, a strong grasp of MS SQL, and the f...

I need a Full Stack Developer comfortable with React, Sass, .NetCore, and SQL Server to work on my website, web application, and mobile/desktop app. The primary goal of this project is to develop a responsive, high quality website that also functions as a web application, with the potential for further expansion into mobile and desktop applications. We are looking forward to have a complete Computerized Maintenance Management System (CMMS) / Maintenance Work Order(MWO). A Complete Control Pannel on Web based asapplication along with the Mobile APP + Desktop APP. With the below added features.:- + It will have Website Fully responsive, Mobile APP, Control Pannel Application + It must fully SAAS Based means related to the SAAS Based all the screen to be designed and implem...

I am searching for a seasoned eBay lister with a min of 5 years experience and a personal active eBay account, for a high-volume clothing listing project. Key Responsibilities: - List 51-100 clothing items per week on my eBay account. - Ensure accurate, appealing, and detailed descriptions of each item. - Apply your knowledge of eBay's best practices to maximize visibility and sales. - Manage the listings post-launch and respond to any customer inquiries. I will provide all the necessary details regarding the pricing and market trends. You should be able to efficiently execute the task with the information provided. Ideal Skills and Experience: - Proven experience in eBay listing, specifically in the clothing niche. - A comprehensive understanding of the eBay platfor...

We are a leading wildlife management and pest control company, renowned for our innovative approaches and award-winning services. We are looking to revolutionize the pest control industry by developing an all-in-one SaaS platform that will streamline operations, offer new-to-industry reporting and transparency, and redefine customer experience. Project Overview: We are seeking a talented freelancer or agency to develop a cutting-edge SaaS platform that will serve as the backbone of our pest control management system. This platform will encompass various modules including CRM, sales, field service management (FSM), asset management (GIS), pest activity reporting, client interaction, and technician reporting. Our company will be the first and primary user of this platform, we will s...

I'm currently facing severe slowdown issues with my WordPress website due to slow MySQL queries. I'm looking for a professional who could help me identify and resolve these performance bottlenecks. plz find attached details

I'm building a site in Oxygen with Advanced Custom Fields. I have created a custom post type with several different categories. I have then also created a custom archive template using a repeatable element. However, I can't get the archive template to display just the posts in the relevant categories. When I go to the front end categories, they either display nothing or all of them.

I'm looking for an experienced professional who understands the PayPal payment gateway system and has the skills to configure it within my WordPress website. I am using WP Travel Engine. In particular, I need assistance setting up post-payment confirmation emails. Key Tasks: - Integration of PayPal Payments Standard: The ideal candidate should be able to seamlessly integrate the PayPal Payments Standard service into my existing WordPress website. Note that it is already integrated but there is an error that was not there before. - Confirmation Email Setup: I need confirmation emails to be sent out after a successful payment has been made. Specifically, I'm looking to create and send out two types of emails: order confirmations (which was already implemented but after the ...

...reliability, leading, advanced, innovative, professionalism, success, modernity, and futurism (Phase 2) after Logo concept approval: 1. Mockup for Business Card Design and Letterhead Design: Address will be provided later 2. CI: Fonts, presentation, stationery ..etc 3- LOGO in action: Font, presentation, on work clothing, disruption vehicles ------------------------------------------------- Budget: - An amount of USD1000 is allocated for this project and is guaranteed as the prize for the best submission, design and proposal. ONLY professional designs. Feedback and Communication: - Submissions will be reviewed daily, and there will always be feedback for improvement. Freelancers can submit multiple proposals. There are several rounds of approval. Fi...

I'm seeking a Flutter developer to build an application that integrates with an API to perform CRUD operations on an SQL database. Key Requirements: - CRUD Operations: The app should be able to create, read, update, and delete records from the SQL database. - Database: The SQL database is the preferred choice for this project. - API Integration: The app should be able to read data via an API, handle user profiles, transactional data, and real-time updates. Ideal Skills: - Proficiency in Flutter development - Experience with SQL databases - Familiarity with integrating APIs - Understanding of CRUD operations - Ability to handle various types of data, including user profiles and real-time updates.

I'm looking for an expert in MS SQL databases to help me with a specific task. I’m using an MSSQL database and need to create a Param scalar. This is to store specific customer information in a structured manner. The ideal freelancer should be experienced with: - SQL, specifically MSSQL - Parameter creation within databases - Experience working with customer information In your proposal, please provide an example of a similar task you've completed in the past.

...PHP/SQL script. I want it to help me capture, store and manage user reviews. The script will also redirect positive reviews to Google/Facebook for example. DEMO: The script aims to help business owners manage their business details, review sites, and customer feedback effectively by sending positive reviews to external review sites such as google or facebook and negative reviews are sent to a feedback form. —-> Please see example for exactly how I want website to look! Must be very clean and dynamic and perfect for mobile first. <— The project's requirements include: - User Review Capturing: The script should allow users to leave reviews without needing to register. - Database Integration: The script should store all reviews in ...

Hello We are changing server and we are facing an issue to import in phpmyadmin some tables of an extension "amasty gdpr" There is lot of tables like this bottom one, those queries are giving error in phpmyadmin : Errcode: 150 "Foreign key constraint is incorrectly formed" They are talking about same problem and extention "amasty" here : We don't know how fix this It works very well on old server but we cannot migrate to new server because of this problem CREATE TABLE `amasty_gdpr_privacy_policy` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Id', `created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Date of creating', `policy_version` varchar(10) NOT NULL DEFAULT '' COMMENT 'P...

data base design (model, sql) 590 laravel auth customized for phone (ALMOST DONE) 2360 Referral logic 2360 referral page register configuration Event Script (creates new even every 3 min will be a cron job for linux) 3540 Additional Pages 2478 { withdrawal page 708 Account details 472 Recharge page 708 Contact us page 826 } Betting Page 4720 includes the following { time and result feature 2000 betting feature 1000 events feature 500 my history feature 500 } Admin Panel 8378 withdrawl 1600 user manage 2000 manage result 1700 past events 800 earnings 1000 TOTAL 21950

...primarily revolve around increasing conversions. - Create and publish engaging content across our active platforms - Facebook, Instagram, and Tik Tok. - Manage the day-to-day running of these social media channels, including interacting with followers, responding to queries, and monitoring the effectiveness of our posts. - Oversee the execution of paid campaigns on these platforms to broaden our reach and ultimately drive more conversions. Requirements: - You should have a proven track record of managing social media channels for small businesses. - Expertise in creating and curating engaging content that drives conversions. - Proficiency in running successful paid campaigns on Facebook and Instagram. - Good knowledge of Tik Tok and its current marketing landscape. I exp...

The task involves loading multiple large data files into a database. These files, approximately 15GB each and in various formats like CSV, .db, .sql, etc., add up to an estimated dataset size of 1-2 TB. Preference is given to keeping the data locally on the machine, thus ruling out cloud storage solutions. The task entails consolidating and organizing fragmented files into a suitable database, whether it's a relational database or non-relational database. Initially, attempting the task with MySQL or any SQL databases is preferred. However, exploration of whether a NoSQL solution is suitable for handling such big data is also required.

...and sql databases but only enough to read and understand code not really create it. i’ve used chat GPT to create a very basic script and it’s not done a bad job however it’s unfinished. I can share my Chat GPT log so you can see the files created and understand the progress. It’s a simple script and most of the code is created. I need someone who can edit the code and fix the functionality. Here is what i was creating: The project is a web-based system for business reviews. It allows businesses to collect customer feedback through a simple landing page with star ratings and additional review links for external review sites. The system includes backend scripts to add businesses and review sites to a database, a frontend landing page to ...

I'm seeking a skilled Data Analyst who specializes in Power BI to handle a range of tasks, including data visualization, data modeling and analytic...to represent data trends effectively. - Develop robust data models that align with my business requirements. - Conduct in-depth data analytics to glean valuable insights. My data sources are primarily Excel spreadsheets and SQL databases. Therefore, expertise with these platforms is vital. Additionally, the candidate must be comfortable working with large datasets, as the project involves more than 10GB of data. Skills and Experience: - Mastery of Power BI for data visualization - Strong background in data modeling and analytics - Proven experience with Excel and SQL data sources - Ability to manipulate and analyz...

...to extract comprehensive data and metrics essential for reporting purposes. Your primary responsibility will involve pulling detailed information from Sales, Orders, Products, Customers, and other relevant sources via the API. Your expertise in navigating the intricacies of the Amazon Seller API to extract pertinent data for reporting is crucial. This data needs to get into Microsoft Excel seamlessly and effortlessly. This will enable easy access and manipulation of the data for reporting purposes. I'm seeking a freelancer with experience in the Amazon Seller API to pull back data and metrics - all columns of data related to Sales, Orders, Products, Customers, and beyond.… Your primary task will be retrieving detailed information for reportin...

I am looking for a freelancer to help me learn SQL from scratch, and show me how to implement SQL in Visual Studio using C# language, using SQL Server Management Studio. 1. Show me how to implement SQL in Visual Studio in the C# Language. 2. I already know C-Sharp well but want to learn how to implement SQL in my basic C-Sharp Order Management System so that when I enter basic order data in the system, CRUD operations perform and save to the database. 3. I have to utilise SQL Server Management Studio as i have no experience in how to connect this to Visual Studio. 4. The focus would be on showing me how to implement my solution using SQL Server Management Studio within Visual Studio 2022. Key Tasks: - Teach me the SQL fu...

I'm currently working on a project that involves fetching data from an API and loading it into SQL Server using SSIS. I've made significant progress, and I'm facing challenges that require immediate attention. Key Details: - I'm encountering error messages during the data loading process. - I require assistance writing the SSIS package to ensure efficient and error-free data transfer. - The data source is an API, so experience handling API data is essential. Skills/Experience Required: - Proficiency in SQL Server Integration Services (SSIS). -Must know SQL server - Ability to troubleshoot and resolve data loading errors effectively. - Familiarity with API keys for authentication.

I'm looking for a resourceful and proficient freelancer to build a cross-platform app (android and iOS) that will integrate with specific tables and queries from Microsoft Access. Role Expectations: - Creating UI that is intuitive and user-friendly. - Integration with MS Access, focusing on certain tables/queries. - Ensuring high performance of the app on both Android & iOS platforms. Ideal Skills: - At least 2 years' experience in cross-platform app development. - Proven experience of integrating apps with databases, extra points for Microsoft Access. - Good understanding of UI/UX principles. Note there’s no need for user registration as all the features would be public.

I am looking for a resourceful freelancer who can revamp my current project by working on its UI, performance, and functionality. An additional integration of AI would be an advantage. In terms of UI, the task includes: - Enhancing the visual design to make it more appealing. - Improving the navigation to ensure seamless user journey. - Simplifying the layout, making it more user-friendly and intuitive. On the aspect of performance improvement, the project aims to: - Achieve faster loading times, enhancing user experience. - Optimize database queries to ensure efficient data retrieval. - Reduce server response times for rapid processing. Ideal skills for this project include proficiency in UX/UI design, performance optimization, and knowledgeable in AI in...

I require a skillful professional with proficiency in Power BI, SSRS, Power Automate, and SQL. The project involves both analytics and reporting. Key Responsibilities: - Develop an effective data model in SQL that supports data analysis and visualization in Power BI. - Implement insightful data visualization and dashboards using Power BI. - Create reports in SSRS for automated distribution. - Develop automated report distribution through Power Automate. Ideal Skills and Experience: - Proficiency in Power BI, SSRS, Power Automate, and SQL. - Strong background in data analysis and visualization. - Experience with creating complex data models. - Previous work on automated report distribution is a plus. The selected candidate will be pivotal in turning our data ...

I HAVE c# windows POS project for inventory management with Azure MS SQL database application. there is also WordPress ecommerce website. I want to display the quantity of each Item in the website based on the stock table in database verse wisa Skills & Experience: - Proficiency in C# programming - Experience in developing Windows applications - Good understanding of inventory systems - Proven experience in WordPress integrations, especially in relation to e-commerce platforms - Quick and effective problem-solving capacities. I am looking for a freelancer who could develop this api professionally with attention to timeliness, accuracy, and secrecy. If you meet the described criteria, I encourage you to bid. who have done same work earlier please bid budget $...

I'm looking to create a straightforward and minimalist online clothing webstore, complete with a database that's setup in the 3rd normal form. The database needs to be designed to utilize at least 2 PL/SQL commands. While the site will carry a simple, generic design, it won't require any login/signup feature for customers. Some of the essential skills and experience for the job include: - Proficiency in database design, particularly with establishing a database in the 3rd normal form. - Experience with executing PL/SQL commands. - Ability to create a minimalistic and generic web design. - Experience in creating online stores, specifically clothing stores, would immensely be helpful.

For details please DM me: The successful candidate will be instrumental in building a highly sophisticated bot that leverages language models to interact contextually with user queries based on extensive text data. This role involves implementing cutting-edge technologies to ensure precise information retrieval and context-aware interactions. Additionally, the role includes another critical project focusing on enhancing data analysis techniques. You will develop systems to evaluate and refine the accuracy of data extraction methods, particularly by minimizing error rates in automated data categorization using language model capabilities. Key responsibilities include coding in Python, integrating open-source language models, and creating robust mechanisms for error ha...

I'm in the process of deploying a SQL API Bicep module code on top of an existing ARM template for our business and I'm facing some issues regarding throughput. I'm looking for a professional who can troubleshoot and ensure the successful deployment of our Azure Cosmos DB setup to meet our business needs. Key Responsibilities: - Troubleshoot and resolve throughput related errors in existing Azure Cosmos DB deployment - Integrate the SQL API Bicep module code with the existing ARM template effectively. Ideal Candidate: - Proven experience with Azure Cosmos DB and SQL API deployment. - Adept at troubleshooting and resolving throughput related issues. - Skilled in integrating APIs with existing systems.

Desarrollo de una app Android para control de check point el cual escaneará un código qr ubicado en distintas ubicaciones geográficas, al momento de escanear el código qr tendrá q guardar una foto, glosa, hora y fecha, y ubicación del GPS en modo of-line. Una ves se tenga conexión enviar esa información a una base de datos sql server(API)

I'm looking for a skilled C# developer who can help with database integration, specifically using SQL Server. Key Requirements: - Database Integration: You will be expected to integrate SQL Server into our existing C# application. This will involve working with database tables, writing queries, and ensuring data is accurately and securely stored and retrieved. - Experience: I'm looking for someone with a strong background in C# development and a proven track record of successful database integration projects. Ideal Skills: - Strong C# Development skills - Proficient in SQL Server - Experience in database integration - Ability to write efficient and secure queries - Good communication skills This is a great opportunity for...

I am currently on the lookout for an expert programmer well-versed in Java, Python, C++, and SQL. You main task is to pass live interview including hackerrank challenges instead of me. Key Requirements: - Extensive experience in programming - Robust problem-solving abilities - Strong knowledge of algorithms and data structures - Proficiency in Java, Python, C++, SQL and pertinent tools or technology Please detail your related experience when applying to gauge if your skill set aligns with the demand of this project. Be ready to demonstrate your problem-solving prowess, thorough understanding of algorithms and data structures, and fluency with the specified languages and tools.

...target demographic for this project is B2C (Business-to-Consumer). Your strategies should be aligned to engage and convert this specific audience. Your main responsibilities will include: - Creating engaging content and monitoring social media campaigns to track their effectiveness in lead generation. - Replying to customer queries and sorting out all details before passing it to me. - Creating posts and captions for the brand. - Note: A file will be sent for reference regarding the items for sale as well as its details. Ideal candidates should have: - Demonstrable experience in online marketing, with a strong record of lead generation for B2C sectors. - Profound understanding of social media platforms, particularly Facebook and Instagram and...

I am often facing lot os issues while importing data into MS SQL server, there are different type of errors and issues that I cannot keep track of. I need someone to help me geet rid of all these issues once and for all... I should be able to import all types of data using XLS, XLSX, CSV and all others..

I need an SQL query to extract specific information from the Moodle database. The query should pull the name of the user, a list of activities they have completed, and the time they have spent on SCORM packages if they have interacted with any. Key requirements include: - Extracting user's name and completed activities. - Differentiating SCORM packages and calculating time spent on them. - Handling users with no completed activities by including them in the results with zero activity count. If you are familiar with PostgreSQL and Moodle database structure, and have experience writing efficient SQL queries, this project is for you. Your query should be optimized for general use, without specific version constraints. The ideal candidate for t...

I'm looking for a developer to create an AI chatbot for my website that primarily serves as a customer support tool. I'm open to integrating an avatar to make the chatbot more engaging and human-like. For reference you can check : Key Features: - AI Chatbot: The core functionality of this project will be to design, develop, and integrate an AI chatbot into my website. - Customer Support: The chatbot's primary function will be to provide customer support, answering common queries and directing users to relevant resources. - Avatar Integration: I'm considering incorporating an avatar to make the chatbot more engaging and personable. I'm open to suggestions on the best way to implement this feature. Skills and Experience: - Proficiency i...

I need an expert Squarespace platform developer to construct a website for my accounting firm. Key features should include a client portal where customers can upload documents and monitor the status of their work. It should also facilitate interaction where queries can be addressed. - The live chat system should primarily support text chat. - The aesthetic appeal is crucial to this project. It should have a clean look with specific landing pages detailing the services offered. Freelancers should provide evidence of past successfully completed projects, especially those related to Squarespace website development and design for businesses. An understanding of user-friendly design very much appreciated!