Sql server 2008 running total punët
Pershendetje Glen. Jam e interesuar per ndihmen tuaj ne SQL. Do te me duhet ndihma jote ne nje provim neser. A mundeni te me ndihmoni me nje shume prej 10 euro per 1 or e gjysem?
Office 365, Wordpress server admin, closed server admin
Programing in Dot Net & SQL Server. Visual Studio 2010, SQL Server 2012 Express ose më të avancuar. Modify existing modules, add modules, design interface, Reports...etc
thank you for being here (container sends email) What in the screens do I need to update - what fields are important ? Please understand; there is hope you can give your “best” price; been unemployed, and have cancer with bills backing up, $10 possible? Please note $10 is the max total that I can handle for this (doing hourly reduces % fee). Will leave a Glowing paragraph of feedback 5 stars : - ) My funds are low but will pay quick and leave 5 stars. Please give your best possible for your bid ? (something reasonable?) Please note there is hope we can mutually complete this task; we can leave each other nice comments and 5 stars for each? Look at feedback on my profile, feedback I left for many others. Here is the project: SINCERELY WOULD BE NICE TO MEET YOU PLEASE...
I'm looking for a part...partnership development - Be well-versed with the TikTok platform and influencer landscape - Possess excellent communication and negotiation skills - Be able to interpret data and draw insights from it to optimize influencer partnerships The influencers we're looking to connect with should: - Have over 5,000 followers - Be in the 'Personal Care' niche. Other categories are also needed but below 50% of total influencers connected within the deliverable period. The successful completion of the job should provide at least 20 connections with the influencers, with their videos published on their TikTok pages. If you're passionate about TikTok, have a keen eye for identifying potential partners, and can build and maintain strong relati...
...to go to college Choose a central character that represents you in the comic strip. This could be a portrait of yourself, a self-created character, or even an animal or object. Select an appropriate setting for your story to take place in. This could be outside, at home, or any other *realistic* area. Use a combination of words and visual elements to convey these reasons in the comic strip. A total of six panels is required but you may also want to include dialogue between characters, or use captions to provide more context. Thats the assignment. Now I have the plot line for the panels I just actually need the comic strip complete. Below is the plot line: Feel free to add or take out and make it look nice Panel 1: Character (you): looking at a photo of your father "Dad, y...
I'm looking for an experienced and knowledgeable SQL Server professional who can help me resolve a connection issue I'm experiencing. - **Connection Method**: I'm currently using Windows Authentication to connect to the SQL Server. - **SQL Server Version**: I'm using SQL Server Management Studio 20. - **Error Message**: When trying to connect, I receive an error message indicating that the connection has failed. Ideal candidates for this project should have: - Extensive experience with SQL Server, particularly with the version I'm using. - Proficiency in troubleshooting connection issues. - Strong communication skills to guide me through the resolution process.
I need to upgrade my existing Google Chrome extension from manifest v2 to manifest v3. - The current extension is running on Google Chrome. - The main goal of the upgrade is to enhance the extension's performance. Ideal Candidate: - Proficient in developing Google Chrome extensions - Experienced in upgrading from manifest v2 to manifest v3 We have existing extension for currency converter. My request is when you'll be upgrading V2 to V3, I will provide you with an Ubuntu operating system where you can install Node.js, npm, and any other tools needed for continuing React development. All development, including future updates, will take place on this server. I want to ensure I can run "npm run build" without any errors because sometimes I may want to ad...
...flat above the bakery to Dirk and Doreen. Last week, following a police investigation, it has emerged that Dirk and Doreen have been using the flat for the purposes of prostitution. Both have been charged with criminal offences under the Sexual Offences (NI) Order 2008. Additionally, they have also been charged with keeping a dangerous wild animal on the premises contrary to the Dangerous Wild Animals (NI) Order 2004. Incidentally, in the course of the police investigation, it was discovered that Carmel has been running a puppy breeding business from an outbuilding at the rear of the premises. The authorities have taken the view that this business involves no illegality, but have advised that Carmel should find more appropriate premises sooner rather than later....
As an individual making use of Google Maps for specific personal applications, I am in need of a freelance developer adept at using VB.Net and SQL database to develop a program that will post activities on Google Maps. This software will be particularly handy in marking and recording various personal activities. The Successful Freelancer: - Should provide evidence of experience in VB.Net coding and SQL database management. Showcasing past work that is similar to this project will be beneficial. - They should also understand the implementation of access levels in software development as the map posting feature will be restricted to admin use only. Main Activities: - Create a software application using VB.Net. - Link the application to Google Maps. - Develop a feat...
I'm facing an issue with my React JS website; it's not loading specifically on Safari for iOS devices. I'm looking for a seasoned React JS developer to guide me through its resolution: - **Issue Details:** The website doesn't load at all; users on iOS Safari currently can't access it. - **Possible Causes:** I suspect the problem might stem from the following: - *Thi...Third-Party Plugins:** A good understanding of how to deal with third-party plugins and their potential conflicts. - **Knowledge of API Integration:** Capable of troubleshooting issues related to API calls. Your role will be to consult with me and potentially provide guidance on resolving the issue. Your expertise in React JS and iOS browser compatibility is crucial in helping me get the website u...
...(Vocalist) to add vocals to a very No-Doubt-esk sounding horn-driven Reggae Pop song, which will be distributed through Sony Music with a substantial marketing budget. Requirements: You MUST have the ability to record on your own. Either with a home (bedroom) studio or the ability to rent out a studio. You will be providing us with unedited 48KHz 32-bit WAV stems in raw format (at least 4 files in total). You will be required to layer/over-dub your own vocals and may send us mixed/mastered vocals as well as the raw files for tracking / reference purposes. Lyrics and a reference of how the vocals should sound will be provided, but you are welcome to make up your own lyrics. The theme is about a fun Summertime song trying to decide what to do on a Friday evening after work an...
I'm in need of a professional to optimize my PL/SQL code for better performance. The primary focus of this project is to enhance the overall efficiency of the code. Key Responsibilities: - Perform PL/SQL performance tuning to improve the execution speed of queries. - Implement bulk collect operations to enhance data retrieval efficiency. - Optimize the compilation of procedures for better code execution. I'm seeking someone with extensive experience in PL/SQL, particularly with performance tuning and bulk collect operations. Proficiency in procedure compilation optimization will be a bonus. Your expertise will play a crucial role in achieving the project's goals.
...amigable e intuitivo que permita a los usuarios buscar partidos / ligas / eventos. Gestión de Usuarios: Implementar un sistema de gestión de usuarios que permita el registro, inicio de sesión y administración de perfiles de usuario con metodologia FREEMIUM Seguridad: Garantizar la seguridad de la aplicación mediante prácticas de desarrollo seguro, como la protección contra ataques de inyección SQL, XSS, CSRF, etc. Equipo Necesario: Desarrollador Full Stack con experiencia en PHP (preferiblemente con Symfony), PostgreSQL y conocimientos sólidos en integración de APIs & Diseñador UI/UX para la creación de una interfaz de usuario atractiva y funcional. Objetivos del Proyecto: Desarrollar un...
I'm seeking a professional to help set up a Windows-based server using virtual machines for the purpose of managing remote profiles. Key requirements: - Proficiency in setting up and configuring Windows Operating Systems - Experience in creating and managing Virtual Machines, particularly in a VPS environment - Prior work in server configurations and network management The ideal candidate will be able to work efficiently, communicate effectively, and provide guidance on scalability and security for the server setup.
I have a website build in PHP 8.3, running on CentOS 8 Apache server and WordPress as the CMS. Currently, the site is facing various errors. I need an experienced professional to fix these. Key Responsibilities: - Warning The optional module, imagick, is not installed, or has been disabled. - Warning The optional module, zip, is not installed, or has been disabled. - Error The required module, gd, is not installed, or has been disabled. - Warning The optional module, intl, is not installed, or has been disabled. - Modules not loading if installed Ideal Candidate: - Proficient in PHP, Apache, and WordPress - Strong debugging and troubleshooting skills - Experienced in fixing a wide range of error types in each of the technologies It's crucial for the successful candid...
I'm seeking a lighting technician specialized in ...for dance shows. The key requirement is expertise in spotlighting to enhance the performance. Ideally, you should have: - Experience working with stage lighting for dance shows - Proficiency in creating compelling spotlighting effects - Great sense of timing and creativity to accommodate changing routines Your role will involve creating a spotlighting plan, setting up the equipment, running tests, and managing the lighting during the performance. Your ultimate goal is to highlight the dancers in a way that enriches the audience's experience. We have a children’s ballet show in a school theatre in weybridge. We need someone on 8 th June for rehearsal and show is Saturday 22 nd June all. lighting per...
Images from models schemes parts. 16 images X 15USD = Total 240USD
...involves setting up a wishlist system, configuring Shopify's product management system, and custom coding for seamless integration. Comprehensive Product Customiser with Dynamic Pricing: Technical Details: Develop a comprehensive product customiser that includes options for adding a gift box and personalisation on the back of the product. When selected, these options should automatically update the total price. Additionally, consider a feature for building custom gift boxes with dynamic pricing updates. Email Marketing Automation and Personalization: Technical Details: Integrate a system for personalising emails based on customer data, such as birthdays, and use wishlist items to generate unique promotions. This involves setting up advanced segmentation and automation usin...
...my project. Key Responsibilities: - Enhancing the existing backend system: Your primary responsibility is to enhance the functionality of the current system and optimize its performance. - Integrating SQL/NoSQL Databases: Your expertise in SQL/NoSQL databases is crucial to ensure smooth integration and efficient data handling. - Experience with Python and Minio: If you're familiar with Minio that's a big plus, but Python is the key language you'll be working with on this project. Ideal Candidate: - Proven experience in enhancing existing backend systems. - Proficient in working with SQL/NoSQL Databases and designing queries. - Strong Python skills are a must. - Experience with Minio is an advantage, but not a necessity. This is a great opportunity...
I have a small petrol station with software running the petrol pumps. I've reinstalled Windows XP and all relevant software on the PC. However, I'm facing difficulty getting the petrol pump controller to communicate with the local MSQL database. Key Points: - The PC is running on Windows XP. - The petrol pump controller uses a serial port for communication. - The issue lies in configuring the connection between the petrol pump controller and the MSQL database. Requirements: - You'd need to have a strong grip on database management, particularly with MSQL. - Proficiency in networking and serial port communication is a must. - Experience with Windows XP is preferred. - Troubleshooting skills and experience in resolving connectivity issues will be highly valued....
Se busca ampliar la cartera de clientes para un servicio en concreto para Agencia de Marketing Digital. El servicio será la captación de clientes potenciales a través de publicidad online para el cliente y también gestión de redes sociales para el cliente. Necesitamos profesionales expe... -Slack para organización óptima del trabajo. -Stripe para realizar el cobro del servicio y cerrar la venta. -Zoom para reunirse con el cliente y cerrar la venta. Se proporcionarán recursos y materiales gráficos para utilizar de apoyo en el proceso de venta. El trabajo se remunerará mediante comisión de un 10% del precio del servicio que se porcentaje se calcula de la facturación total que se consiga en la prim...
hello i need a freelancer to change design of wordpress website to make it same freelancer should change the design live website not only mockup website details: built on WP Dev is ok no change we share screenshots of what should be done total 6 pages: 1- home page 2- map&table page(index page) 3-contact us 4-about us 5-terms and conditions 6-privacy and policy freelancer should not touch my other domains on my hosting and dont change anything without asking me freelancer should follow my admin panel: what original developer give me you should give same he gave me editing control on all pages (text editor) 10 days maximum good luck
Hello, I would like to hire someone who can create a complete discord server, with bot design, channels, etc.
As someone who values efficient and cost-effective operations, I'm intent on leveraging the full potential of my Microsoft SQL Server database. The core of this project involves enhancing performance and decreasing cost. To enrich the function of my database, I'll need an expert who can: - Improve overall performance, guaranteeing smoother, faster operations - Implement strategies for cost reduction without compromising quality and performance The ideal freelancer will be someone with extensive experience in Microsoft SQL Server, superb knowledge in database performance enhancement, and proven strategies for cost-reduction. If you can deliver this, you'd be the perfect fit.
I am in need of a skilled and experienced individual who can take charge of a brand revamp project. The successful candidate will be responsible for managing the rebuild of our brand, which includes a website redesign, social media strategy development, via team hiring and delegation. ****The project is a long-term commitment for the right candidate.**** Key Responsibilities: - Devise a robust marketing and social media strategy to boost our online presence. - Hire and delegate tasks to a team of professionals to ensure the brand revamp's success and to take over several major tasks such as social media / content creation, blogs, incorporating affiliate marketing, product sourcing - Allocate budget effectively to maximize project impact. Ideal Candidate: - Experienced in marketi...
...your PROPOSED GARAGE CONVERSION PROJECT with an approximate 470 area. --- SCOPE OF WORKS: Phase A: SCHEMATIC DESIGN 1. Architectural Solution - $175 1.1. 3D Modeling and 3D Visualizations - $125 Once the schematic design is approved, we will now move on to the next phase which is the; Phase B: DETAILED DESIGN 1. Detailed Plans, Elevations, Sections, and other necessary details - $150 --- Total Architectural Design Cost: Four hundred fifty US Dollars ($450) Submission of Initial Design: May 24, 2024 Friday Number of Revisions: 3 Deliverables: - Detailed Drawings (in PDF format) - 3D Visualizations - Sketchup File ($150) Note: 1. Additional revisions beyond the included revisions: $75 per revision. Thank you for allowing me to submit my proposal and I look forward to being o...
Perfect english is needed. You need to be able to teach and tutor me in relational data bases and sql. You must be able to share screen and communicate quickly and fast. You must be available from today till 24th of May. I'm looking for an experienced database professional to assist with a relational SQL database project. You will need to assist me to answer questions about the following: The required tasks include: - Relational data bases ( administration, normalisation, sql workbench, my sql, data modelling) - Writing SQL queries - Designing the database schema - Optimizing query performance This project specifically involves MySQL, sql workbench, so proficiency in this database system is a must. The complexity level of the project...
I'm looking for a professional who can support me in my Azure Data Factory project. My primary goal is to transform structured data and then load it into Azure SQL Database and visualize it in Power BI. Deal with incremental load, create table relation and contextual data. Skills and Experience: - Proficient in Azure Data Factory - Experience in working with structured data - Expertise in data transformation - Knowledge in loading data into Azure SQL Database - Ability to visualize data in Power BI
I'm in need of an experienced web developer who can help us launch an e-commerce website as soon as possible. We're looking to have our new site up and running with a minimum of 20,000 products. Key Requirements: - Proficiency in WooCommerce: Since WooCommerce is our preferred e-commerce platform, you should be well-versed in working with it. - Large Dataset Handling: As the site will have between 20,000 to 30,000 products, you should be comfortable and experienced in handling such large datasets. - Urgent Availability: Due to the urgency of this project, we need someone who can commit to working on it promptly. Design and Platform Suggestions: - Design Features: I'm looking for specific design features to be incorporated into the site, including custom product filt...
...up later with the right content. + Start page + main categorie side + under categorie side + article page - our design team will assits you by questions. - you have to import the articles from our actually side to the new development side - modify the checkout based on the customer requirements - If this work is running smoothly and good, we can work on a hourly base as well for several add ons by this new page. Could be a long term relation ship. Key requirements and responsibilities include: - Implementing the design I provide using Elementor and the WoodMart theme - Ensuring the website is optimised for e-commerce, with a particular focus on enhancing user experience and driving sales - Providing guidance
UK MRICS QS ONLY (MAY ACCEPT SIGNIFICANT EXPERIENCE QS WITH NO MRICS BUT DEGREE FROM UK) Comprehensive schedule of materials needed, listing all materials required for the job, by delivery date/stage of works and not simply a total amount. For example, bricks might be a total quantity of 10,000 bricks, but it wouldn't be feasible to order all this at once, we need to know when to order, at what stage of the build and how much of it. Another example might be steel beams, might need to order ground floor beams first, then first floor/2nd floor. The project will be a 18-Week Build with a 4-man team (2 x labourers, 2 x multi-skilled). Start date: June 3rd 24. Building regs, Structural drawings, Architect drawings, Landscape drawings, Drainage drawings, Site photos. Ele...
...such as show everything that happened on the 14/5/2024 or show all instances of Opened Chrome. They should also be able to change their email address and password. We do not need the ability to block or limit anything, just to report. In the admin panel it should show the following: List of users accounts with ability ti view accounts - Reset user's password, etc Number of devices installed Total Number of devices each user has it installed on The app needs to have the following configured: AdMobs Google Analytics/Firebase Analytics Firebase Crashalytics OneSignal. We may look to charge a subscription fee in the future but at the moment it will be free with ads. Ads show on app open and after a period of time being used when logged into the app. Ideal Skills and Experi...
We are the largest and fastest growing UK charity community delivering support through multiple services via our website. Our website and AI machine learning and GPT are handled by others. We need dev support for the core SQL system and 2 small SQL directories, plus running reports and system admin. We need full stack Microsoft .NET development experience, strong SQL knowledge and exposure to Azure Microsoft services. We require a range of services. We’ll begin with the ad hoc work to begin to build a working relationship and then build that up to the following on an ongoing basis. • Ad hoc tasks for minor tweaks and changes on an ongoing basis. • Larger pieces of work, such as creating a moving from a free to a free and premium versions, ...
Are you a talented Crochet Pattern Designer? Apply here and help make our subscription kits shine! Your assignment will be to create captivating and beginner-friendly crochet patterns. You'll be a key player in making sure our kits are exciting, easy to follow, and match our theme perfectly. Please note that our themes revolve around Amigurumi. Design and deliver a total of 4-5 original cute crochet patterns suitable for beginners, in line with our theme. (farm animal, ocean creatures, unicorns, etc) Provide clear and comprehensive written instructions for each pattern, including any necessary diagrams or visual aids. Optionally, create video tutorials demonstrating the creation of each pattern. We are looking for the following experience : Ability to create original croch...
I'm looking for a seasoned digital marketing professional to handle a complete range of digital marketing campaigns across various platforms. Key Responsibilities: - Managing Google platforms including Google Tag Manager, Google Analytics, and Google Ads. - Handling social media advertising across Facebook, TikTok, and Snapchat. - Experience with other platforms such as X Ads and running Install App Campaigns with Tracking Codes. - The primary focus is on Conversion Optimization, so the ideal candidate should be skilled in maximizing app installation. The ideal candidate should have: - Expert-level experience in digital marketing (5+ years). - A proven track record of optimizing conversion rates across different platforms. - Strong analytical skills and experience in data-d...
We are seeking a Business Data Analyst for our team who is willing to work with new ...Responsibilities: - Collect and analyze data from various sources - Identify patterns, trends, and correlations in datasets - Create reports and dashboards to present findings - Collaborate with cross-functional teams to understand business requirements Required skills: - Strong analytical and problem-solving skills - Proficiency in data analysis tools such as Excel, SQL, or Python - Experience with data visualization tools such as Tableau or Power BI - Excellent communication and presentation skills This is a great opportunity for individuals who are new to the field of business data analysis and are looking to gain practical experience in a supportive en...
...the following abilities: Inky is his name a playful and mischievous ink blob character with a fluid and ever-changing form. Their body can morph into various shapes, from simple geometric patterns to intricate designs. Inky is mostly black but can also change color depending on their mood or surroundings. They have big, expressive eyes that can convey a wide range of emotions. - Jumping and running: The character will need to be designed in a way that it can smoothly perform these basic actions essential for a platformer. - Shooting projectiles: The character should also be able to shoot projectiles, so the design should incorporate relevant features that allow for this action. Ideally, I'm looking for someone who has experience in 2D character design, particularly in th...
...sources including databases, APIs, and files - Proficiency in data transformation, aggregation, and cleaning -Bachelor's degree in Computer Science, Engineering, or related field. -2+ years of experience as a Data Engineer or similar role. -Hands-on experience with PySpark, Scala, and Azure Databricks is required. -Experience with data modeling, ETL development, and data warehousing concepts. -Strong SQL skills and proficiency in data manipulation and analysis. -Experience with cloud platforms (Azure preferred) and big data technologies. -Optionally, experience with SSIS and SSAS is a plus. -Proven experience with POWER BI, Tableau, HADOOP, MongoDB etc. -Excellent problem-solving and communication skills Be ready to understand the specifics of the project once selected and ...
I am looking for an experienced Ionic Developer to fix my app. i have an issue with my app that can't be build to Android SDK 33+. I've tried uninstall some plugin which is end up crashing at splashscreen as it only display a white blank. The job is to make my app can be build to Android SDK 33+ and compatible with lower SDK, no more error, crash and missing current feature i.e running in backround, notification, GPS. You have to make detail documentation on how you do it and what setting did you use, the timeline is 4 days and i'm willing to pay you $120 and that's final offer. And please, APPLY IF YOU UNDERSTAND WELL THE CASE AND WILLING TO BE PAID AS I OFFERED.
A friend is running for the mayor's office in Focșani, Romania as a candidate. He has very slim chances, but I thought to ask for your help to create some nice banners for his Facebook/social media profile. foto of my friend is Name : Cristian Zîrnă Slogan1: Luăm Focșaniul înapoi! / Reprezintă Focșaniul, nu partidele! Slogan2: Nu partidele, ci oamenii decid. / Construim Focșaniul împreună, fără partide. Slogan3: Cristian Zîrnă, un primar independent. / Vocea independentă a Focșaniului. color pallets is foto.
I'm in need of an experienced individual to migrate my current Moodle site from a shared server to a dedicated server. This move is primarily to prepare for an expected increase in traffic, and I'm looking for someone who can not only handle the technical aspects of this migration but can also help with optimizing the server for improved performance. Key Requirements: - Expertise in server migration, specifically Moodle - Ability to create a custom configuration for performance optimization - Prior experience in handling increased traffic on a dedicated server Please only apply if you have experience with Moodle and can guarantee a smooth migration process.
I need fresh email addresses from users in Germany! These should not come from web scraping or web crawlers, but from real users who have participated in contests, signed up for newsletters, or requested information on lead platforms, for example. The data must be current and deliverable. Only data from users in Germany is sought, in both the B2B and B2C...who have participated in contests, signed up for newsletters, or requested information on lead platforms, for example. The data must be current and deliverable. Only data from users in Germany is sought, in both the B2B and B2C sectors. B2C email addresses (freemailer addresses) are preferred. Acceptance will be based on a trial run in batches of 50,000 to 100,000 pieces (expandable), with a total volume needed of 10,000,0...
I have running my website on WordPress, am providing property related services. So my contact us form not working getting error during to submit the details and need some plugin updates as well. Required developer who can handle this updates for existing WordPress site...thanks
I'm seeking a data-savvy freelancer with a deep understanding of Instagram, to create a well-organized spreadsheet of micro influencers. There are three crucial components needed for each influencer: I AM NOT LOOKING TO CREATE FAKE SOCIAL ACCOUNTS - I WANT EMAIL ADDRESSES TO CONTACT THEM TO HELP CREATE CONTENT> 1. Instagram Handle 2. Number of followers 3. Their Email Search Criteria - total of 2000 records acrsoss - Dieticians and Nutritionists - Pregnancy and infertility - Mums / Working Mums 500 - 5000 followers only. Australian-Based Accounts
I'm in need of a skilled photo editor to handle a large batch of images for my e-commerce platform. The work will primarily involve basic retouching, color correction, and background removal. Key Requirements: - Extensive experience in phot...e-commerce purposes - Proficiency in basic retouching techniques - Skilled in color correction to ensure images are visually consistent - Capable of seamlessly removing and replacing backgrounds - Ability to work on a high volume of photos - Familiarity with e-commerce photo requirements and standards The selected freelancer will be provided with a substantial number of images, more than 50 in total. Candidates with a strong portfolio showcasing previous e-commerce photo editing work are highly preferred. Looking forward to seeing ...
...entails several key responsibilities: For the SLAVE devices coding : 1. Each slave device should feature an initialization green LED that indicates successful wireless communication with the master device. 2. Additionally, each slave will have two LEDs, one red and one blue, which will illuminate when specific buttons (B1 to B3 for blue team, R1 to R3 for red team) are pressed by the user. 3. With a total of six buttons per slave device, each responsible for assigning marks to either the blue or red team, the coding should incorporate a mechanism to ensure the validity of button presses within a one-second timeframe. Only when certain conditions are met—such as simultaneous presses of specific buttons or receiving button signals from multiple slave devices—should mar...
I need help to fix th...our ecommerce site, however its never worked properly and actually impacts on even simple daily tasks - the freelancer who developed this for us is unwilling to assist correcting the problems. Customers are now identifying that the app is not working and they are walking ie we are loosing customers, orders and money. Freelancers bidding on this project will be expected to show evidence of PWA running from Magento. The chosen freelancer will be hired on an hourly fee basis and expected to completely remove the existing PWA and build a new system - using functionality from the existing PWA wherever possible to minimise cost. Please note that we're looking for professionals who have experience with similar projects and are able to provide solutions in a...
